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-