I've created a few simple macros to help me maintain a simple user list.
I would like to use names to define columns, rows, cells and ranges and use them in my macros. For example, part of a macro might use:
Columns("D:P").Select
Selection.EntireColumn.Hidden = True
I can give a name to column D and to Column P but I can't figure out how to use it correctly in the macro. I imagine that I'd use something like:
Columns(phoneNumber:addressLine3).Select
but this gives an error.
It's likely something very simple that I need to do but I can't find the trick via the help information.
Can you help, Please
Thanks
Bob Summers
Ottawa, Ontario, Canaga
Bookmarks