How do I use vb to move from worksheet to worksheet in a workbook.

[Guest]

I am using VB (Excel) and want to be able to move from sheet to sheet in a
macro and finish at the last sheet. Any ideas??

 

[Job]

For Each wksht In ActiveWorkbook.Worksheets...

HTH,

Job

 

[Chip Pearson]

If you don't need to actually select the sheets, use something
like

Dim WS As Worksheet
For Each WS In ThisWorkbook.Worksheets
' do something with WS
Next WS

If you do need to select the sheets, put a Select statement
within the loop above:
WS.Select


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Tom Ogilvy]

With ActiveWorkbook
for each sh in .Worksheets
msgbox "in sheet: " & sh.Name & vbNewLine & _
"cell A1: " & sh.Range("A1").Value
Next
.Worksheets(.Worksheets.count).Select
End With