keith05281967
Board Regular
- Joined
- May 6, 2011
- Messages
- 68
Greetings Repository of Excel knowledge,
I have a macro that scrubs incoming files. One of the things it does is check the active cell range. The files are of varying size so there is no hard coded range.
The below code selects the activeCell range. I'd like to take it one step further and show on screen the bottom right corner of the selected range. That way the user can see at a glance if the range is correct.
It would be even better if there were a few rows and columns buffer in the view to clearly see where the bottom right selection ends. Example: if bottom right of selected range was R65, then i'd like the bottom right of my screen to be S66 or T67.
'look at ActiveCell range
Range("A1").Select
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
I hope this is clear. Thanks in advance for your input.
Keith
I have a macro that scrubs incoming files. One of the things it does is check the active cell range. The files are of varying size so there is no hard coded range.
The below code selects the activeCell range. I'd like to take it one step further and show on screen the bottom right corner of the selected range. That way the user can see at a glance if the range is correct.
It would be even better if there were a few rows and columns buffer in the view to clearly see where the bottom right selection ends. Example: if bottom right of selected range was R65, then i'd like the bottom right of my screen to be S66 or T67.
'look at ActiveCell range
Range("A1").Select
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
I hope this is clear. Thanks in advance for your input.
Keith
