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)
I am trying to use the code above to take the value of B2 and autofill
it based on the value in cell GX1. GX1 contains cords like "B2:B6500".
Any help is greatly appreciated!
|