praetorian
New Member
- Joined
- Jan 19, 2005
- Messages
- 11
This is too difficult for me.
I have worksheet_change code that runs through a FOR EACH (CELL IN RANGE) loop. When the loop has finished I would like the macro to check where the active cell is and (this is the tricky bit):
If there was only one cell in the loop, and the active cell is in column F, then shift the active cell to Column J of the same row
or
If there were two or more cells in the loop, and the active cell is in column F, then (1) shift the active cell to Column D of the same row, then (2) bring a text box up reminding the user to close the workbook ready for the next user.
I have worksheet_change code that runs through a FOR EACH (CELL IN RANGE) loop. When the loop has finished I would like the macro to check where the active cell is and (this is the tricky bit):
If there was only one cell in the loop, and the active cell is in column F, then shift the active cell to Column J of the same row
or
If there were two or more cells in the loop, and the active cell is in column F, then (1) shift the active cell to Column D of the same row, then (2) bring a text box up reminding the user to close the workbook ready for the next user.