I would like to write a VBA macro which all it does is take the selected range from one sheet and selects and goes to that range on another sheet. I can't figure out exactly how to extract just the cell references without the sheet references from the selection object.
For sake of example lets say I start on sheet1 with a range selected, and want to go to sheet2 with the identical range selected.
Anyone know how?
For sake of example lets say I start on sheet1 with a range selected, and want to go to sheet2 with the identical range selected.
Anyone know how?