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