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/385117-range-b2-autofill-destination-%3Drange-gx1-activecell-fails-but-why.html)

[email protected]

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!



All times are GMT +1. The time now is 11:55 AM.

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