| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy range and paste into every 3rd cell of new range | New Users to Excel | |||
| Paste a named range to another range in Excel | Excel Discussion (Misc queries) | |||
| Range Paste in VBA | Excel Programming | |||
| how do i paste a range? | Excel Programming | |||
| Paste a Range from a variable | Excel Programming | |||
Threaded Mode
