Expand a Range non VB

Good afternoon starbwoy

...and welcome to the forum!!

Originally Posted by starbwoy

I named some ranges in my workbook. Now I have to add columns and rows to each range. How do I do this?

If you have set up a named range and you add columns or rows within that range, then the named range will alter to accomodate those rows / columns.

HTH

DominicB