| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple "source" workbooks linked to single "destination" workboo | Excel Worksheet Functions | |||
| use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
| Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming | |||
| Help with "Autofill" Destination Range | Excel Programming | |||
Linear Mode
