Re: $$Excel-Macros$$ Question

On Tue, Oct 18, 2016 at 3:23 PM, सचिन शर्मा wrote: > Dear All, > > Please help to resolve the attached Question > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discuss

$$Excel-Macros$$ Question

Dear All, Please help to resolve the attached Question -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor

$$Excel-Macros$$ QUESTION FOR SOLVER

in the attachment, there is no figure in column F and in column N there is an average if i need the averages as per my requirements then how can I get through solver, please show the steps.. thanks in advance... -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(

Re: $$Excel-Macros$$ QUESTION FOR DAYS DIFFERENCE

Thank you for your help On Monday, 11 January 2016 10:11:15 UTC+5, Abhi wrote: > > When you are subtracting, you are excluding the start date. > > > > On Mon, Jan 11, 2016 at 10:30 AM, Izhar > > wrote: > >> Please open the attachment see the question. >> Thanks in advance. >> >> -- >> Are you =

Re: $$Excel-Macros$$ QUESTION FOR DAYS DIFFERENCE

but if we subtract 4-2 we get 2 and and then add the same two into 2 we get 4 then why in the date if I take a loan from a bank, the banker wont include the first date in view of applying markup rate on my loan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIM

Re: $$Excel-Macros$$ QUESTION FOR DAYS DIFFERENCE

When you are subtracting, you are excluding the start date. On Mon, Jan 11, 2016 at 10:30 AM, Izhar wrote: > Please open the attachment see the question. > Thanks in advance. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join officia

$$Excel-Macros$$ QUESTION FOR DAYS DIFFERENCE

Please open the attachment see the question. Thanks in advance. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titl

Re: $$Excel-Macros$$ Question : Form control of Excel 2007

Ashish Sir, Thank you. This is working. You have solved my big problem. With Regards, *Suyog* On Wednesday, 3 July 2013 20:23:41 UTC+5:30, ashish wrote: > > try this macro see if it helps > > Sub add_comboboxes() > > Dim rng As Range > Dim cl As Range > Dim shp As Shape > > For Each shp In A

Re: $$Excel-Macros$$ Question about function

Thanks for the reply. 2013/7/3 Waseem Saifi > Dear Van, > > I have placed a formula in first sheet in K column. > it might help you. > > > On Mon, Jul 1, 2013 at 12:47 AM, Bé Trần Văn wrote: > >> Question 1: I need one function to the column numbered F. >> >> Question 2: In column J, How to con

Re: $$Excel-Macros$$ Question : Form control of Excel 2007

try this macro see if it helps Sub add_comboboxes() Dim rng As Range Dim cl As Range Dim shp As Shape For Each shp In ActiveSheet.Shapes If shp.Type = msoFormControl Then shp.Delete Next Set rng = Range("b3:b10") For Each cl In rng ActiveSheet.DropDowns.Add(cl.Left,

$$Excel-Macros$$ Question : Form control of Excel 2007

Hello All, I've created one form control & copy and paste them all the way down the column, hoping that the linked cell will get auto update like normally happens while copy-pasting of any normal formula. Now I've to set all individually set up the cell link for each one. Is there anyway of c

Re: $$Excel-Macros$$ Question about function

Thanks for your help Please thank. 2013/7/1 De Premor > istied using SUMPRODUCT, we can also use SUM with CSE > > {=SUM(--($C$2:C2=C2)) &". ("&TEXT(B2,"dd/mm/")&") - "&D2} > > Rgds, > [dp] > > > On 01/07/2013 7:33, Norman Cliff May wrote: > > If the countif function is not available to you,

Re: $$Excel-Macros$$ Question about function

istied using SUMPRODUCT, we can also use SUM with CSE {=SUM(--($C$2:C2=C2)) &". ("&TEXT(B2,"dd/mm/")&") - "&D2} Rgds, [dp] On 01/07/2013 7:33, Norman Cliff May wrote: If the countif function is not available to you, the following formula should work in cell E2 and copy down. =SUMPRODUCT(-

Re: $$Excel-Macros$$ Question about function

If the countif function is not available to you, the following formula should work in cell E2 and copy down. =SUMPRODUCT(--($C$2:C2=C2))&". ("&TEXT(B2,"dd/mm/")&") - "&D2 On Sun, Jun 30, 2013 at 3:17 PM, Bé Trần Văn wrote: > Question 1: I need one function to the column numbered F. > > Ques

Re: $$Excel-Macros$$ Question about function

Another suggestion would be to put the following formula in cell E2 and copy down. =COUNTIF($C$2:C2,C2)&". ("&TEXT(B2,"dd/mm/")&") - "&D2 Delete the columns to the right of column E On Sun, Jun 30, 2013 at 3:17 PM, Bé Trần Văn wrote: > Question 1: I need one function to the column numbered

Re: $$Excel-Macros$$ Question about function

I think the following formula does everything you are wanting to do if you paste it into cell F2 and copy down. =IF(E1=E2,(LEFT(F1,FIND(".",F1,1)-1))+1,1)&". ("&TEXT(B2,"dd/mm/")&") - "&D2 Then you could delete the columns to the right of column F On Sun, Jun 30, 2013 at 3:17 PM, Bé Trần Văn

Re: $$Excel-Macros$$ Question about function

Change the formula in J2 from =F2&G2&H2&I2&D2 to =F2&G2&TEXT(H2,"dd/mm/")&I2&D2 On Sun, Jun 30, 2013 at 3:17 PM, Bé Trần Văn wrote: > Question 1: I need one function to the column numbered F. > > Question 2: In column J, How to connect string (F & G & H & I & D), > without losing formatting

$$Excel-Macros$$ Question on SumProduct Formula

Hi All, I am seeing many examples of SUMPRODUCT formula on this forum and very interested in using this in my assignment. I see that this formula is very short and fast. I am presently using SUMIFS for most of my calculations, where I am creating the SUMIF formula in a cell by concatenating entri

$$Excel-Macros$$ Question on My Menu !!

Hello All, I'm using Ashish Sir's "My Menu ver 1.6" very frequently & that increased my working speed in excel. I'm really thankful for same. Please refer attached my question regarding "insert" option of my menu. Please advice on my question. With Best Regards, Suyog -- Join official facebo

Re: $$Excel-Macros$$ Question chart

will not get quick attention or may not be answered. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com -Original Message- From: PRAVESH KUMAR Sent: Thursday, September 06, 2012 11:18 PM To: excel-macros ; excelvbaclinic Subject: $$Excel-Macros$$ Question chart HI

Re: $$Excel-Macros$$ Question chart

or may not be answered. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com -Original Message- From: PRAVESH KUMAR Sent: Thursday, September 06, 2012 11:18 PM To: excel-macros ; excelvbaclinic Subject: $$Excel-Macros$$ Question chart HI Team, please help m

Re: $$Excel-Macros$$ Question chart

Hi Anil, a lot of thanks! for help me, you reduced my workload of a month, in some moment. Thanks Pravesh On 9/7/12, अनिल नारायण गवली wrote: > Dear Pravesh, > > See i have changed the dropdown working . > pls do the color , as i'm busy with other work. > > On Fri, Sep 7, 2012 at 9:48 AM

Re: $$Excel-Macros$$ Question chart

Dear Pravesh, See i have changed the dropdown working . pls do the color , as i'm busy with other work. On Fri, Sep 7, 2012 at 9:48 AM, PRAVESH KUMAR <> wrote: > HI Team, > > > please help me to solve this queston it's very urgent. > > solve asap. > > > > -- > > Thanks & Regards > > Pravesh Kuma

Re: $$Excel-Macros$$ question for noorani

The link provided below has a lot to do with the CALL function which is not supported in latest versions of Excel. If you want to learn about XLM functions (Excel4), try this link which has an in-depth explanation of the GET.DOCUMENT and GET.CELL functions http://www.excelfox.com/forum/f13/excel-m

Re: $$Excel-Macros$$ question for noorani

Dear Danial, Best Resource of Excel4 Function is : *http://www.cpearson.com/excel/Call.htm* -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, May 29, 2012 at 3:35 PM, danial mansoor wrote: > how can we get excel 4 functions?any resource? > >

$$Excel-Macros$$ question for noorani

how can we get excel 4 functions?any resource? Date: Tue, 29 May 2012 15:31:25 +0530 Subject: Re: $$Excel-Macros$$ MACRO From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com Dear Sagar, Please find attached study material of Basic Macro and follow excel-macro group on regular ba

Re: $$Excel-Macros$$ Question in Excel

ue/2012 10:05 > *To:* excel-macros > *Subject:* $$Excel-Macros$$ Question in Excel > > ** ** > > Hi, > > ** ** > > I make dummy sheet to get to know , where i am facing problem , and I > marked as Yellow Color . I also give my solution , but that is only half , &g

RE: $$Excel-Macros$$ Question in Excel

Try this: From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of neil johnson Sent: Jan/Tue/2012 10:05 To: excel-macros Subject: $$Excel-Macros$$ Question in Excel Hi, I make dummy sheet to get to know , where i am facing problem , and I marked as

Re: $$Excel-Macros$$ Question in Excel

Thanks Noor Ji, For your quick reply. On Tue, Jan 17, 2012 at 11:38 AM, NOORAIN ANSARI wrote: > Dear Kapil, > > Pls see attached sheet with Index+Small > > > On Tue, Jan 17, 2012 at 11:08 AM, neil johnson > wrote: > >> Thanks a lots . >> >> >> On Tue, Jan 17, 2012 at 10:41 AM, Maries wrote: >

Re: $$Excel-Macros$$ Question in Excel

Dear Kapil, Pls see attached sheet with Index+Small On Tue, Jan 17, 2012 at 11:08 AM, neil johnson wrote: > Thanks a lots . > > > On Tue, Jan 17, 2012 at 10:41 AM, Maries wrote: > >> >> *Find the attachment...* >> >> On Tue, Jan 17, 2012 at 8:34 AM, neil johnson >> wrote: >> >>> Hi, >>> >>> I

Re: $$Excel-Macros$$ Question in Excel

Thanks a lots . On Tue, Jan 17, 2012 at 10:41 AM, Maries wrote: > > *Find the attachment...* > > On Tue, Jan 17, 2012 at 8:34 AM, neil johnson > wrote: > >> Hi, >> >> I make dummy sheet to get to know , where i am facing problem , and I >> marked as Yellow Color . I also give my solution , but

Re: $$Excel-Macros$$ Question in Excel

*Find the attachment...* On Tue, Jan 17, 2012 at 8:34 AM, neil johnson wrote: > Hi, > > I make dummy sheet to get to know , where i am facing problem , and I > marked as Yellow Color . I also give my solution , but that is only half , > I need complete solution. I need your help . Please find the

$$Excel-Macros$$ Question in Excel

Hi, I make dummy sheet to get to know , where i am facing problem , and I marked as Yellow Color . I also give my solution , but that is only half , I need complete solution. I need your help . Please find the attached sheet. -- FORUM RULES (986+ members already BANNED for violation) 1) Use con

Re: $$Excel-Macros$$ Question

hu On Tue, Aug 9, 2011 at 4:06 AM, dguillett1 wrote: > > Homework? > > -Original Message- From: XLS S > Sent: Monday, August 08, 2011 3:38 PM > To: excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ Question > > Q-1 )    Can I write VBA code to

Re: $$Excel-Macros$$ Question

Homework? -Original Message- From: XLS S Sent: Monday, August 08, 2011 3:38 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Question Q-1 )Can I write VBA code to protect or unprotect my VB Project? Q-2) Why does Excel have two macro languages? Q-3) Can I

$$Excel-Macros$$ Question

Q-1 )Can I write VBA code to protect or unprotect my VB Project? Q-2) Why does Excel have two macro languages? Q-3) Can I lock cells such that only specific users can modify them? Q-4) When I enter a value, it appears with two decimal places. For example, when I enter 123 it shows u

RE: $$Excel-Macros$$ Question regarding Sheets

End If Next End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of neil johnson Sent: Friday, July 22, 2011 8:04 PM To: excel-macros Subject: $$Excel-Macros$$ Question regarding Sheets Hi all, I have two sheets . in these sheets i

Re: $$Excel-Macros$$ Question on VBA

Thanks Rakesh, as I would like to get the copy range changed depending on the variable I set in the macro. Actually, the code I wrote is something like below x = worksheetfunction.counta(worksheets("Sheet1").range("a:a")) worksheets("Sheet1").range(cells(3,1),cells(x,1)).copy . . Sorry I am

Re: $$Excel-Macros$$ Question on VBA

ells(y,1),cells(y,6)) > > Regards. > Daniel > > -Message d'origine- > De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De > la part de Ming > Envoyé : mardi 28 juin 2011 14:42 > À : MS EXCEL AND VBA MACROS > Objet : $$Excel-Macros

Re: $$Excel-Macros$$ Question on VBA

*instead of : you should use , while using cells in range reference* On Tue, Jun 28, 2011 at 6:12 PM, Ming wrote: > Hi all, > > I have written below syntax but got an error but I can't figure out > why > > worksheets("sheet1").range(cells(x,1):cells(x,6).copy > worksheets("sheet2").range(cells(y

RE: $$Excel-Macros$$ Question on VBA

(cells(y,1),cells(y,6)) Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Ming Envoyé : mardi 28 juin 2011 14:42 À : MS EXCEL AND VBA MACROS Objet : $$Excel-Macros$$ Question on VBA Hi all, I have written below synta

$$Excel-Macros$$ Question on VBA

Hi all, I have written below syntax but got an error but I can't figure out why worksheets("sheet1").range(cells(x,1):cells(x,6).copy worksheets("sheet2").range(cells(y,1),cells(y,6)) However, I can do it if I seperate it as follows: worksheets("sheet1").range(cells(x,1):cells(x,6).copy workshe

$$Excel-Macros$$ Question for you Excel Masters out there...

Greetings, I have a question I am hoping to find the answer of here... I have a spreadsheet that signifies that includes revenue which is represented on my pivot charts as bars represented by a month (a good example but I could come up with others of course). Simple enough right? Well what if I

$$Excel-Macros$$ Question on Pivots

Hi, I have a testing scenario where I have Severity (Critical, High, Medium & Low) and I have modules as Insurance, Claims, etc. When I take a pivot, I want to combine all the module information in the body of the pivot showing Severity in Row labels and all the other info under summation of Total

$$Excel-Macros$$ Question about excel

Hello, I have details in summary sheet and i want the details posted to the respective sheet also. Do we have any method to have details posted to the respective sheets. Example in summary tab i have west region details and the entire row of west should also be in West sheet also is there any m

Re: $$Excel-Macros$$ Question about list box

Hello, Your answer lies in the properties of list box which are given below. Add a list box (Form control) 1. If the *Developer* tab is not available, display it. [image: Show]Display the *Developer* tab

$$Excel-Macros$$ Question about list box

Hi Sir, - *I am not understanding that Code : When I use listbox.value it shows index number like 0 in excel sheet. While When I use listbox.list(listindex) display the value correctly. * *What is difference between them. * Thanks and Regards -- -

Re: $$Excel-Macros$$ Question about excel report

try this formula =MID(CELL("address",Sheet1!A1),FIND("]",CELL("address",Sheet1!A1))+1,99)&" = "&Sheet1!A1 On Fri, Sep 3, 2010 at 6:08 AM, jjsmd wrote: > > Hi: >  I am new to excel and I was wondering hiw I would do the following. >  I have an excel worksheet with names of people in a sheet goin

$$Excel-Macros$$ Question about excel report

Hi: I am new to excel and I was wondering hiw I would do the following. I have an excel worksheet with names of people in a sheet going from column A to X and row 1 to 10. I would like to get a worksheet showing the location and then name. Ex: A1=John, A2=Smith and so on. Is this easily done? a

Fwd: $$Excel-Macros$$ Question asked in Interview...

-- Forwarded message -- From: Ahmed Honest Date: Sun, Aug 8, 2010 at 12:08 PM Subject: Re: $$Excel-Macros$$ Question asked in Interview... To: excel-macros@googlegroups.com Hai, Our Favourite buddy in this group Mr. Dave has already given attention and replied to your query please see it again. I

Re: $$Excel-Macros$$ Question asked in Interview...

l > > 048542 > > -- Forwarded message -- > From: Vijay Kr. Aggarwal > Date: Sat, Aug 7, 2010 at 9:16 AM > Subject: Fwd: $$Excel-Macros$$ Question asked in Interview... > To: excel-macros@googlegroups.com > > > Hello Friends, > > Waiting for re

Fwd: $$Excel-Macros$$ Question asked in Interview...

048542 -- Forwarded message -- From: Vijay Kr. Aggarwal Date: Sat, Aug 7, 2010 at 9:16 AM Subject: Fwd: $$Excel-Macros$$ Question asked in Interview... To: excel-macros@googlegroups.com Hello Friends, Waiting for reply Regards, Vijay -- Forwarded message

Fwd: $$Excel-Macros$$ Question asked in Interview...

Hello Friends, Waiting for reply Regards, Vijay -- Forwarded message -- From: Vijay Kr. Aggarwal Date: Fri, Aug 6, 2010 at 10:18 AM Subject: $$Excel-Macros$$ Question asked in Interview... To: excel-macros@googlegroups.com Hi, Please check attached file. Kindly provide

$$Excel-Macros$$ Question asked in Interview...

Hi, Please check attached file. Kindly provide answers through macro and functions. Regards, Vijay Kumar Aggarwal 048542 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and li

RE: $$Excel-Macros$$ Question re: cell comments and validated lists

You're welcome Dave. > Date: Sun, 1 Aug 2010 10:24:21 -0700 > Subject: Re: $$Excel-Macros$$ Question re: cell comments and validated lists > From: simon_mc_webs...@yahoo.co.uk > To: excel-macros@googlegroups.com > > That's it exactly! Many thanks Dave, > &g

Re: $$Excel-Macros$$ Question re: cell comments and validated lists

That's it exactly! Many thanks Dave, Sid. On 1 Aug, 13:32, Dave Bonallack wrote: > I forgot to say that the drop-down is in C1 > > Regards - Dave. > > > Date: Sun, 1 Aug 2010 01:36:25 -0700 > > Subject: $$Excel-Macros$$ Question re: cell comments and validated

RE: $$Excel-Macros$$ Question re: cell comments and validated lists

I forgot to say that the drop-down is in C1 Regards - Dave. > Date: Sun, 1 Aug 2010 01:36:25 -0700 > Subject: $$Excel-Macros$$ Question re: cell comments and validated lists > From: simon_mc_webs...@yahoo.co.uk > To: excel-macros@googlegroups.com > > Good Evening Gurus, &

RE: $$Excel-Macros$$ Question re: cell comments and validated lists

Hi, I think this can only be done with an event macro. Have a look at the attached. regards - Dave. > Date: Sun, 1 Aug 2010 01:36:25 -0700 > Subject: $$Excel-Macros$$ Question re: cell comments and validated lists > From: simon_mc_webs...@yahoo.co.uk > To: excel-macros@goog

$$Excel-Macros$$ Question re: cell comments and validated lists

Good Evening Gurus, I have a quick question (the answer to which has probably been staring me in the face all day!). Is it possible to make a selection from a drop down validated list and have the associated comment attached to the cell in that list 'follow' the selection to the target cell? For

Re: $$Excel-Macros$$ *Question*: Match/Sumif functions to merge rows in in large datasheet

e combined claim values. let me know if you need a step-by-step example. Paul From: Skin To: MS EXCEL AND VBA MACROS Sent: Mon, June 7, 2010 4:47:52 PM Subject: $$Excel-Macros$$ *Question*: Match/Sumif functions to merge rows in in large datasheet I am havin

$$Excel-Macros$$ *Question*: Match/Sumif functions to merge rows in in large datasheet

I am having some trouble figuring out a problem. Anyway, I am working with a large dataset, so it is obviously not efficient to do this by hand, so hopefully someone can help me out. This is how my spreadsheet is set up: Year|Last Name|First Name|$ amount|Cholesterol Level|Height|Weight However,

$$Excel-Macros$$ Question about "Extract Number FROM Alphanumeric String"

Hello! This website is a wonderful resource! Thank you so much for it. I have been slowly learning VBA on my own and often read through code to try to learn. My question concerns the sample provided by Shyam on March 30, "Extract Number FROM Alphanumeric String". The function works wonderfully

Re: $$Excel-Macros$$ Question about Index function

t occurrence of 1. > > Regards - Dave, > > > > > > > Date: Mon, 29 Mar 2010 16:38:39 -0700 > > Subject: $$Excel-Macros$$ Question about Index function > > From: tomfabtas...@hotmail.com > > To: excel-macros@googlegroups.com > > > Hi, > > >

RE: $$Excel-Macros$$ Question about Index function

nd False's. The double negative outside the bracket changes these to 1's and 0's, which are then handed to the Match, which is looking for the first occurrence of 1. Regards - Dave, > Date: Mon, 29 Mar 2010 16:38:39 -0700 > Subject: $$Excel-Macros$$ Question about I

$$Excel-Macros$$ Question about Index function

Hi, I have a formula that works, but I'm not sure how the INDEX function is working: =MATCH(1,INDEX(--(ATM!$C$3:$AJ$3=6),0),0) The INDEX part of the above searches for a 6 in the range ATM!$C$3:$AJ $3. The -- appears to create an array. Is the -- shorthand for another function ? Regards, Tom

$$Excel-Macros$$ Question about QueryTable

In VBA is there a way to create a dynamic QueryTable? I have a website to which I need to post different variables. When the webpage returns, I need to import a table into a worksheet then post another parameter and then import those results, etc. Is there a way to do this? --

$$Excel-Macros$$ Question

Hi firends My Question is how to convert numerical in words to in Ms Excel ? -- sudhir --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutori

$$Excel-Macros$$ Question

Hi all friends Please sent me any excel file which is define the macro. i can't understand the macro in excel and i always think that what its use in excel. Thanking U Have nice Day!!! Sudhir Kumar --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ Question: on Application.GetOpenFilename command

When you used the Application.GetOpenFilename command. Is there a way to make the file opened a active window so that I can store the filename as a string. This is what I am doing so far and it is not working. OpenFile_2 = Application.GetOpenFilename(FileFilter:="Excel Files (*.xls)

$$Excel-Macros$$ Question about validation

Hello, I use validation to select a value from an area to be inserten in the new location. It works fine, but . . . It takes the value from the source cell instead of a reference. So when I change the value in the source cell the new value that I copied from there with the validated list, does no

$$Excel-Macros$$ Question about validation

Hello, I use validation to select a value from an area to be inserten in the new location. It works fine, but . . . It takes the value from the source cell instead of a reference. So when I change the value in the source cell the new value that I copied from there with the validated list, does no

$$Excel-Macros$$ Question

I am trying to input a loop While/Wend with If statements in between but it's showing me this code as an error: While InputSheet.Cells(iInputRow, 2) <> "" Does anyone have a clue why??? Help would be really appreciated!! Thanks a lot! Ana --~--~-~--~~~---~--~

$$Excel-Macros$$ question on graphing pls help

Say, i have 6 columns I want to plot the first 3 columns on one chart format it. Then i want to select the next 3 columns and have it in the same format as the first chart. The charts should all line up next to each other. This is just an example, but the columns can be increased to say 33. This