parkerbelt2
New Member
- Joined
- Sep 22, 2016
- Messages
- 3
I'm trying to Autofill a header from 1 cell to the next using named ranges. I can't seem to get the syntax right. I originally wanted to just use the Offsets rather than creating new variables for the Copy Range and the PasteRange, but I was having too much trouble.
Here's what I'm trying:
Here's what I'm trying:
VBA Code:
Range(SplitCellHolder).Select
PasteRange = Range(SplitCellHolder).Offset(2, 0).Address
CopyRange = Range(SplitCellHolder).Offset(2, -1).Address
Range(CopyRange).Select
Selection.AutoFill Destination:=Range("Range(CopyRange).Address ":" Range(PasteRange).Address), Type:=xlFillDefault