Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy formula
I saw a post on how to do this and now I can't find it.... I need a formula
to copy down until there is a blank entry on the adjacent column.. I think someone called a "copy down" macro... or something.. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy formula
Pick a column that has data all the way down to ascertain the last row(Lrow)
I used F Sub Auto_Fill() Dim Lrow As Long With ActiveSheet Lrow = Range("F" & Rows.Count).End(xlUp).Row Range("G1:G" & Lrow).FillDown End With End Sub You do know that a siimple double-click on the fill handle of G1 would copy down to bottom of F? Gord Dibben MS Excel MVP On Thu, 2 Aug 2007 10:38:04 -0700, len wrote: I saw a post on how to do this and now I can't find it.... I need a formula to copy down until there is a blank entry on the adjacent column.. I think someone called a "copy down" macro... or something.. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy formula
Hi Gord, Just the answer I was looking for, it works excellent for me I hope
it helped Ien as well. Eduardo "Gord Dibben" wrote: Pick a column that has data all the way down to ascertain the last row(Lrow) I used F Sub Auto_Fill() Dim Lrow As Long With ActiveSheet Lrow = Range("F" & Rows.Count).End(xlUp).Row Range("G1:G" & Lrow).FillDown End With End Sub You do know that a siimple double-click on the fill handle of G1 would copy down to bottom of F? Gord Dibben MS Excel MVP On Thu, 2 Aug 2007 10:38:04 -0700, len wrote: I saw a post on how to do this and now I can't find it.... I need a formula to copy down until there is a blank entry on the adjacent column.. I think someone called a "copy down" macro... or something.. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy formula result (text) only - without copying formula | Excel Discussion (Misc queries) | |||
I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Copy formula so destination displays formula as text | Excel Discussion (Misc queries) |