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

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??

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

For Each wksht In ActiveWorkbook.Worksheets...

HTH,

Job

"Ed123" wrote in message
...
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??

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

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





"Ed123" wrote in message
...
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??

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

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

--
Regards,
Tom Ogilvy

"Ed123" wrote in message
...
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??