I need to do the following,
I have a workbook with lots of worksheets in it and each worksheet contains lots of
links, for example a link named abc123456 that opens the abc123456 worksheet. The problem is that the cursor is always placed
at cell A1 in the abc123456 sheet that is open. I need the cursor to stay at the same location as it was before, because I
will copy and paste with vba code and need to know what row that was last copied, (that is the same as the cursor was last
placed on) but i guess that is not possible when using links within workbooks like this.
So to solve this, I
though I could create a variable for each worksheet that is created and store the
possition of the cursor with this code:
But, I want the "sheetrng" name to created automatically depending on the worksheet name.
For example if the worksheet name is abc123456, then the I would like the line to declare the
variable to be like this.
Rng_abc123456 = ActiveCell.Address(RowAbsolute:=False,
abc123456 = ActiveCell.Address(RowAbsolute:=False, ColumnAbsolute:=False)
If I can manage to do this, then I know what line I was last on and can then place the cursor at the "right" row
after following a link.
Would very much like help to solve this.