LinkBack URL
About LinkBacks
I have a spreadsheat were macro1 is cast days. I want to assign another macro to make the cursor no matter where I am on the page move to the last time macro 1 was run.Any ideas?
I have a spreadsheat were macro1 is cast days. I want to assign another macro to make the cursor no matter where I am on the page move to the last time macro 1 was run.Any ideas?
Add a new name to the workbook, say LastCell
Make the last line in macro 1: ActiveWorkbook.Names.Item("LastCell").Value = ActiveCell.Address(0, 0)
Ben Van Johnson
I am not sure I follow. Here is my code, could you help alittle further?
Please Login or Register to view this content.
Last edited by Cutter; 08-03-2012 at 05:30 PM. Reason: Added code tags
@ tperkins1973
Welcome to the forum.
Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.
1. Did you create the Name? If you did not, copy the macro below to the workbook and run it ONE time.
To save the last cell used by CastDay, put the line below as the last line of the CastDay macro, not the first:Please Login or Register to view this content.
Please Login or Register to view this content....I want to assign another macro to make the cursor...move to the last time macro 1 [i.e., CastDay] was run...
So, when you write the macro that's going to use that cell address add the below:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks