Range Cut and Paste
I have been trying to cut a range and paste it using the offset method
using the Range /offset method. I can select the range easy enough, I just
can't seem to paste it using offset . Here's my failed code:
Range(ActiveCell, ActiveCell.End(xlToRight)).Cut (Offset(-3, 1))
I just want to take the range, and move it up 3 rows and over 1 column
Thanks for your help.
|