Hi,
I am trying to do something like a user first selects a range in a excel sheet. Then he hits the TAB key which makes the cursor to move within the selected range. I want this to be done by a macro once the user has triggered it after selecting a range.
Each time a macro sends a TAB command to the sheet the cursor should move to next within the selected range without deselecting the whole range.
Anyone who can help me creating this would be a great help to me.
Thanks in advance.
>
Premanshu.
I am trying to do something like a user first selects a range in a excel sheet. Then he hits the TAB key which makes the cursor to move within the selected range. I want this to be done by a macro once the user has triggered it after selecting a range.
Each time a macro sends a TAB command to the sheet the cursor should move to next within the selected range without deselecting the whole range.
Anyone who can help me creating this would be a great help to me.
Thanks in advance.
>Premanshu.
