Thread
:
Macro to loop thru sheets & return to a1 cell
View Single Post
#
5
Posted to microsoft.public.excel.programming
CassieM
external usenet poster
Posts: 4
Macro to loop thru sheets & return to a1 cell
Thank you all so much. I can see my beginner's error now!
"Don Guillett" wrote:
try this. No loop
Sub fixsheets()
Sheets.Select
Range("a1").Select
Sheet1.Select
End Sub
--
Don Guillett
SalesAid Software
"CassieM" wrote in message
...
I am a newbie. I'm trying to write a macro to loop through all of the
sheets
in a workbook and return the cursor to the home (A1) position. Seems like
it
should be fairly simple to me, but I just can't get it to work. Thanks
for
your help.
Reply With Quote
CassieM
View Public Profile
Find all posts by CassieM