| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple "source" workbooks linked to single "destination" workboo | Excel Worksheet Functions | |||
| Range("B2").AutoFill Destination:=Range("GX1", ActiveCell) ... Fails but why? | Excel Programming | |||
| 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
