I would like to end a macro with a specific cell (e.g. E50) in the first cell in the upper left hand corner of the screen. How might I accomplish this?
I would like to end a macro with a specific cell (e.g. E50) in the first cell in the upper left hand corner of the screen. How might I accomplish this?
Hello nebb,
Like this...
Or if you rather have the VBA translate the row and column from a given cell. Change "E50" to whatever address you want.Please Login or Register to view this content.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Please Login or Register to view this content.
To Leith Ross: Thanks for your reply. Your second suggestion worked great. The first one gave me a run-time error 1004 on " .ScrollColumn = E" and indicated "unable to set the ScrollColumn property of the window class".
To Palmetto: Thank you also for your reply. worked great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks