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) 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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range("B2").AutoFill Destination:=Range("GX1", ActiveCell) ... Fails but why?
sometimes on autofill you have to select TWO cells to pull down (don't
know why)..... try range("b2:b3").autofill blah blah also, you're mixing RC references (R1C1) with letter/number references (B2) - you have to choose one or the other, i believe. hth susan On Mar 13, 12:55 am, wrote: 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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range("B2").AutoFill Destination:=Range("GX1", ActiveCell) ... Fai
If I understood it correctly, this is what you're looking for:
With Sheets("export") .Range("B2").FormulaR1C1 = "=skus!R2C1" .Range(.Range("GX1").Text).FillDown End With " wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range("B2").AutoFill Destination:=Range("GX1", ActiveCell) ... Fails but why? | Excel Programming | |||
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 |