AutoFill a formula down a column

G

Guest

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
 
G

Guest

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
Autofill with Column as a variable 5
Create named range of cells with values in row 7
Autofilling a formula down 2
Autofill range 2
Autofill variable range 2
cannot autofill 2 cells info at the same time 1
Column width and Row height test? 4

Top