MattN

Ok - I'm getting there honest.

I have a vlookup formula and I want to copy it down throught the spreadsheet. The problem as usual is the spreadsheet has a different number of rows each time.

I can't find away of just selecting the cells that need filling. The F5 special almost works but just copies in the formuala exactly as it appears in the first vlookup and so returns that value throughout. I need to Vlookup formula to select the corresponding cell each time not the same one!!!!

It must be easy????

MattN

scoobynet fails????? That's a first

Fosters

more info? what's the forumla doing? Do you need to know the number of rows?

Martingb

Matt,

I normally use a do loop method to create formuale down a sheet.
Example code to calculate column B * C:

Dim iCounter as Integer 'Used to increment for each row

range("a2").select
iCounter = 2 'Match to the first row of the starting point

do
activecell.offset(0,3).formula="=B" & icounter & " * C" & icounter
activecell.offset(1,0).select ' Move to next row
iCounter = iCounter + 1 ' Increment counter
loop until activecell.value = "" 'Loops down column A until a blank cell is found
Range("a1").select

The vlookup can be substituted to the formula.

if you need any more help email me.

Martin.

MattN

cheers Martin