Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoFill
I would like a macro to be able to autofill a row when I import data. The
problem I'm facing, is the amount of rows will always be changing. I was hoping there was a code that would fill until the end of the data. Any suggestions would be appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoFill
Autofill a row or column?
Sounds like the latter to me since part of description says "the amount of rows will always be changing". Do you want to fill down to end of data in an adjacent column? What do you want to fill down with? Let's say you entered a formula like =A1*B1 in C1 and wanted to fill down as far as there was data in column B. Sub Auto_Fill() Dim lRow As Long With ActiveSheet lRow = .Range("B" & Rows.Count).End(xlUp).Row .Range("C1:C" & lRow).FillDown End With End Sub Gord Dibben MS Excel MVP On Fri, 11 Dec 2009 11:34:01 -0800, dwake wrote: I would like a macro to be able to autofill a row when I import data. The problem I'm facing, is the amount of rows will always be changing. I was hoping there was a code that would fill until the end of the data. Any suggestions would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autofill | Excel Worksheet Functions | |||
Autofill | Excel Discussion (Misc queries) | |||
autofill | Excel Discussion (Misc queries) | |||
Autofill? | Excel Discussion (Misc queries) | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) |