Autofill macro: filling for range whilst there is a value in cell

Cheers for the reply Roy. Unfortunately I haven't explained my self very well.

Basically this macro will be used on adifferent sheets sent by my suppliers every week. It is a list of prices of things I have bought from them for that week. Someweeks O have bought 50 things. Others 100 etc. I am creating the macro to calculate my prices based on the price they send.

Therefore there is the "supplier price" column and to the right "My Price". I want the macro to copy the forumula in the first cell of "My Price" and run down the column until the final product. Like I say, sometimes it is 100, sometimes more. Sometimes less.

Am I making sense?

I know but this is one part of a very long sequence of things I need to do to the sheet before printing.

I've done it though based upon the lngRows function you gave me:

Dim lngRows As Long
lngRows = Range("H2").CurrentRegion.Rows.Count

' Add my Prices
Selection.AutoFill Destination:=Range("I2:I" & lngRows), Type:=xlFillDefault

Cheers!