Thread
:
Macro to loop thru sheets & return to a1 cell
View Single Post
#
4
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Macro to loop thru sheets & return to a1 cell
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
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]