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.
Those are different offsets - how should the code determine what offset you want?
The script should be based on the selected cells.
I mean how does it know how far to offset from the selection?
I guess there is no way...thanks will find a work around
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?
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
