Macro to erase all data and formating in a named range except background color.
Posted by Nona Sloven on May 18, 2001 10:01 AM
My named range is named GreenRange. I need a simple macro to erase all data and formating in all the cells in the named range except the backgound color. It should get rid of borders, bold type fonts should be set to regular fonts, and any data in the range. I know this macro is simple but I have not been able to work around. Thank you in advance.