Solved: Loop in Excel

[ssinghal]

I want to manipulate some data on all worksheets in a particular workbook except the last 6 sheets. The number of worksheets will not be constant. Could someone help with the code to do this? Thanks.

[Bartek]

Hi,


I want to manipulate some data on all worksheets in a particular workbook except the last 6 sheets. The number of worksheets will not be constant. Could someone help with the code to do this? Thanks.

Use something like that:


For Xi=1 to Worksheets.Count - 6

'your code here for Sheets(Xi)

Next Xi

[mdmackillop]

For i = 1 To Sheets.Count - 6
Sheets(i).Range("A1")=2
Next

[ssinghal]

How do I make it go to the next worksheet? It is performing my action on the first sheet everytime.

[mdmackillop]

My code should enter a value on each sheet except the last six. Can you post your code?

[ssinghal]

I figured it out. I needed Sheet(i).Select in my code.
Thanks.