macro to name a certain range

Hi all,

I need a macro to name a range at column B and C. I want to use the upmost cell of column B as a name of that range, and cells from B2 to last non-blanc cell of B and C would be the range itself. (B and C columns have always the last non-blanc cell at the same row)

How about if after the area has been named, I insert rows or columns so that this named range moves to new position, is it possible to automatically update the range to still mean the right cells?

Thank you all

-Juhanen-

Thank you Simon, now it works just like I wanted

regards,

Juhanen

student,

Please read the Forum Rules about posting questions in other people's threads.