View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
john john is offline
external usenet poster
 
Posts: 9
Default 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.