copying formula to a randow row

O

Ole

I want to use the autofill to copy a formula
by using a macro. When I register the macro VBA suggests ie
Selection.AutoFill Destination:=Range("C1:C8")

but I don't want to predetermine how long the range is to be, because it can
vary from 100 to 25000 rows, and I want the copy function to stop at the
last cell that has a value to the left.

Thanks Oystein (Norway)
 
F

Frank Kabel

Hi
try something like

lastrow = Activesheet.Cells(Rows.Count,"B").End(xlUp).Row
Selection.AutoFill Destination:=Range("C1:C" & lastrow)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Copying formulas in range and pasting in a selection 3
Copy Rows based on count of last row of another Column 1
Copy down formula macro 3
Eliminate blanks while copy row and transpose 11
Determine number of rows with data 6
Modify range in VBA 9
Formatting and copy or copy and formatting ?? 2

Top