Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable row...
Copy down list to variable row?
Range("A3").Select Selection.End(xlDown).Select Row = ActiveCell.Row Range("m4:w4").Select Selection.AutoFill Destination:=Range("m4:E" & Row) Range("m4:E" & Row).Select should be simple :) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable row...
If you are cxopying columns M:W, then the destination should be M:W, not
M:E. Also using Row as a variable name is not a good idea, it is a VBA property. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "John" wrote in message ... Copy down list to variable row? Range("A3").Select Selection.End(xlDown).Select Row = ActiveCell.Row Range("m4:w4").Select Selection.AutoFill Destination:=Range("m4:E" & Row) Range("m4:E" & Row).Select should be simple :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum cells based on a row variable and seperate column variable | Excel Worksheet Functions | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
Run-time error '91': "Object variable or With block variable not set | Excel Programming | |||
Cells.Find error Object variable or With block variable not set | Excel Programming | |||
Pivot Table - Object variable or with block variable not set? | Excel Programming |