Hi,

I have a formula in, say, cell K1 and I want to fill it downwards - but only up to a specific row which is defined by the length of a list I have copied from another workbook.
Say that list has 33 entries - but it might be different. I can find the last row of this and fill it into a variable no problem.
How do I have to write the command for auto-filling the formula down to row 34 now?
The usual command >> Selection.AutoFill Destination:=Range("K2:K34"), Type:=xlFillDefault <<
won't work of course because I cannot be certain that 34 is the last row - that's why I have that variable. I just can't seem to get the syntax right to fill that into this command ...
Can anybody help me there?

Thanks a lot!

Best regards,

Officer_Bierschnitt