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

You need:

OK,

I've made it. A bit of a detour probably as I used a formula written to the worksheet - but it works.

Ah. Debaser, I hadn't seen your post just now. Yes, that would be one step easier than what I did - I generated the exact cell reference (like L32) and then created a string_variable like > L2:L32 < that I could then put in the brackets.