Log In
Register
Home
December 4, 2018
Offline
Hey Team,
Is there a way to OffSet a selection range of cells to a different location. I need a script that is dymanic for example:
Offset:
Selected Cells range A1:A5 to C1:C5 or B1:B10 to E1:E10 using the same script, which should be based on selected ranges.
Script being used to select range is as below:
'Range("A1").Select
'Range(Selection, Selection.End(xlDown)).Select
Rgds,
Themba.
Trusted Members
Moderators
November 1, 2018
Offline
Those are different offsets - how should the code determine what offset you want?
December 4, 2018
Offline
The script should be based on the selected cells.
Trusted Members
Moderators
November 1, 2018
Offline
I mean how does it know how far to offset from the selection?
December 4, 2018
Offline
I guess there is no way...thanks will find a work around
Trusted Members
Moderators
November 1, 2018
Offline
There are plenty of ways but you haven't explained what you want. Do you want a prompt to specify how many columns across to offset? Or should it actually be a fixed number in spite of your examples?
October 5, 2010
Offline
Hi Themba
as Velouria said, you haven’t explained what you are trying to do or why you are doing it. If we don’t understand the problem and the result you expect it’s difficult to provide help.
Regards
Phil
1 Guest(s)
