AutoFill a formula down a column

C

CLR

Hi All........
I'm using the code below to try to AutoFill a formula down a column as far
as the column to the left has data therein. Getting varying
results.....sometimes it works right, sometimes 1 or 2 rows short, and
sometimes goes way past the present end of the adjacent column to where it
used to be last time there was data there.......please help.


Range("i8").Formula = "=H8 + G8"
Range("i8").Select
Selection.AutoFill Destination:=Range("i8:i" &
ActiveSheet.UsedRange.Rows.Count)

Vaya con Dios,
Chuck, CABGx3
 
T

Tom Ogilvy

Range("i8").Formula = "=H8 + G8"
Range("i8").Select
Selection.AutoFill Destination:=Range("i8:i" & _
cells(rows.count,8).End(xlup).Row)
 

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

revise CONCATENATE code 2
Need help with a formula 3
Autofill with Column as a variable 5
Autofill Error 4
Create named range of cells with values in row 7
Autofilling a formula down 5
autofill without a destination range 7
autofill down until reach variable range 3

Top