Range("B2").AutoFill Destination:=Range("GX1", ActiveCell) ... Fails but why?
Hey,
Sheets("export").Select
Range("B2").Select
ActiveCell.FormulaR1C1 = "=skus!R2C1"
Range("B2").AutoFill Destination:=Range("GX1", ActiveCell)
This code fails even though the santax of the code makes perfect
sense. What I am trying to do is the following...
Range B2 contains a formula I want auto filled from the cordinates
posted in cell GX1. Any ideas? Thanks!
|