Offset a variable range

[starcraftbud]

Hey guys,

Need some help. Should be a quick hitter. Just need a syntax/function lesson.

I've declared a range which spans several columns. I paste the range in a new location and now want to add a formula offsetting (0,-1) from the first column in my range.

Here is a simplified piece of code

Please Login or Register  to view this content.

This fills only the top cell in my range. Since the range changes, I don't know how many rows it will be. How can I fix this?

I'm trying to learn something new. I could autofill (but this might create complications with only 1 row in the range) or I would have selected the (0,-1) offset cell and run a loop filling in the formula until the offset cell to the right is blank. But there has to be a way to use the range to finish it off. As always, thanks for the help - I really appreciate it.

[StephenR]

Try this

Please Login or Register  to view this content.

[starcraftbud]

Interesting.

Resize is a new one for me. That worked. Thank you very much.