Re: $$Excel-Macros$$ Loop through

2014-04-27 Thread Pramod Singh
My Pleasure. On Mon, Apr 28, 2014 at 11:25 AM, Rupesh Patil wrote: > Dear Pramod, > > Thanks you very very much. > > > On Mon, Apr 28, 2014 at 11:19 AM, Pramod Singh wrote: > >> Hi Rupesh, >> >> Please find the attached file. as per ur requirement. >> >> Regards/Pramod >> >> >> >> On Mon, Apr 28

Re: $$Excel-Macros$$ Loop through

2014-04-27 Thread Rupesh Patil
Dear Pramod, Thanks you very very much. On Mon, Apr 28, 2014 at 11:19 AM, Pramod Singh wrote: > Hi Rupesh, > > Please find the attached file. as per ur requirement. > > Regards/Pramod > > > > On Mon, Apr 28, 2014 at 10:03 AM, Rupesh Patil > wrote: > >> Hello Expert, >> Good Morning >> >> I ne

Re: $$Excel-Macros$$ Loop through

2014-04-27 Thread Pramod Singh
Hi Rupesh, Please find the attached file. as per ur requirement. Regards/Pramod On Mon, Apr 28, 2014 at 10:03 AM, Rupesh Patil wrote: > Hello Expert, > Good Morning > > I need your help, > I am not able to determine how to loop through only till last used row and > column, sample file is atta

$$Excel-Macros$$ Loop through

2014-04-27 Thread Rupesh Patil
Hello Expert, Good Morning I need your help, I am not able to determine how to loop through only till last used row and column, sample file is attachment, Please go through it and help me out. -- Thanks and Regards, Rp. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

Re: $$Excel-Macros$$ loop through cell

2012-03-07 Thread dguillett1
Send direct to dguillett1 @gmail.com Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: LearnExcel Sent: Wednesday, March 07, 2012 4:33 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ loop through cell Don work Great thanks

Re: $$Excel-Macros$$ loop through cell

2012-03-07 Thread LearnExcel
Don work Great thanks For Each ws In ThisWorkbook.Worksheets If InStr(1, ws.Name, vbTextCompare) = 0 _ what ?? And InStr(1, ws.Name, "Doc", vbTextCompare) = 0 Then i use this code to not look at the "doc" sheet, is there a better way? i have 10 sheets that i want the the code to run o

Re: $$Excel-Macros$$ loop through cell

2012-03-07 Thread vijayajith VA
Hi learn excel.. Please send it with attachment.. it will be helpful.Thanks/// On Wed, Mar 7, 2012 at 8:16 AM, LearnExcel wrote: > help with code > > > Dim ws As Worksheet > > can someone tell me why the follwowing code wont work > > > >For Each ws In ThisWorkbook.Worksheets >If

Re: $$Excel-Macros$$ loop through cell

2012-03-07 Thread dguillett1
day, March 06, 2012 8:46 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ loop through cell help with code Dim ws As Worksheet can someone tell me why the follwowing code wont work For Each ws In ThisWorkbook.Worksheets If InStr(1, ws.Name, vbTextCompare) = 0 _

$$Excel-Macros$$ loop through cell

2012-03-06 Thread LearnExcel
help with code Dim ws As Worksheet can someone tell me why the follwowing code wont work For Each ws In ThisWorkbook.Worksheets If InStr(1, ws.Name, vbTextCompare) = 0 _ And InStr(1, ws.Name, "Doc", vbTextCompare) = 0 Then Columns("C:C").EntireColumn.AutoFi

$$Excel-Macros$$ Loop through count and add date

2009-06-18 Thread wongsol
Hello: I'll try to explain as best I can. I have a spreadsheet with a column that have numeric values. What I need to do is loop through these values to a sum no greater than 5000 (doesn't matter in which order); the tricky part that I have no idea where to start is to enter a date in the adjac