Select Cell A1 in all worksheets

[keith156]

Hello,
I've been working for a while to get this macro to work but haven't been successful yet. I'd like to save this macro in my personal xls folder so that I can select cell A1 in each of the worksheets in a workbook. I work with workbooks with multiple worksheets and need a faster way to return the view to the upper left corner of the worksheet, like hitting Ctrl + Home. I had this macro working in a workbook with a defined # of worksheets but haven't been able to make the macro dynamic enough for all workbooks books.


Below is the latest version of many attempts.

Please Login or Register  to view this content.

I would greatly appreciate any assistance you can provide!

Thank you
Keith

[StephenR]

Not sure what you're doing, but does this work?

Please Login or Register  to view this content.

[Leith Ross]

Hello Keith,

If the macro works then it should run from your Personal.xls. So, what is the problem?

I had this macro working in a workbook with a defined # of worksheets but haven't been able to make the macro dynamic enough for all workbooks books.

[keith156]

Yes!! Looks like I took the long complicated route to the macro. Thank you!