ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Range("B2").AutoFill Destination:=Range("GX1", ActiveCell) ... Fails but why? (https://www.excelbanter.com/excel-programming/385116-range-b2-autofill-destination-%3Drange-gx1-activecell-fails-but-why.html)

[email protected]

Range("B2").AutoFill Destination:=Range("GX1", ActiveCell) ... Fails but why?
 
Hey all...

Sheets("export").Select
Range("B2").Select
ActiveCell.FormulaR1C1 = "=skus!R2C1"
Range("B2").AutoFill Destination:=Range("GX1", ActiveCell)

Range B2 contains the formula I want to AUTOFILL based on the range
value shown in GX1...

I can't figure out why this isn't working...I've searched the boards
but the code doesn't work...Any ideas? Your help is greatly
appreciated. Thanks alot!



All times are GMT +1. The time now is 04:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com