LFCdenmark
New Member
- Joined
- May 3, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I have a huge workbook with lots of columns. Some of them are hidden. I have made a simple macro that shows the hidden columns and another macro hiding them again.
In the 1st edition (of the macro) the cursor was send to cell A2 but now the users want the cursor to remain in the same cell it was in before the macro was executed.
Is it possible?
If so, how do I do that?
Here's the "show" macro:
Columns("T:AB").Select
Selection.EntireColumn.Hidden = False
Range("A2").Select
I have tried with these commands as well:
ActiveCell.Offset(1).Select
ActiveCell.Offset(-1).Select
but with no effect.
In the 1st edition (of the macro) the cursor was send to cell A2 but now the users want the cursor to remain in the same cell it was in before the macro was executed.
Is it possible?
If so, how do I do that?
Here's the "show" macro:
Columns("T:AB").Select
Selection.EntireColumn.Hidden = False
Range("A2").Select
I have tried with these commands as well:
ActiveCell.Offset(1).Select
ActiveCell.Offset(-1).Select
but with no effect.