randyharris
Board Regular
- Joined
- Oct 6, 2003
- Messages
- 88
Hi,
I would appreciate a little VBA help.
In my workbook, on the Menu worksheet in Cell D20 will be a number between 1 and 12.
I am making active Cell G9 on the Trended Data worksheet, and what I am trying to do is move the selected cell to the right by the same number as indicated in cell D20 on the Menu worksheet.
So if for example when G9 is selected on Trended Data, let say D20 on Menu = 7, I'd like to move my selected cell on Trended Data to the right 7 columns which is N9.
Thanks,
Randy
I would appreciate a little VBA help.
In my workbook, on the Menu worksheet in Cell D20 will be a number between 1 and 12.
I am making active Cell G9 on the Trended Data worksheet, and what I am trying to do is move the selected cell to the right by the same number as indicated in cell D20 on the Menu worksheet.
So if for example when G9 is selected on Trended Data, let say D20 on Menu = 7, I'd like to move my selected cell on Trended Data to the right 7 columns which is N9.
Thanks,
Randy