Excel 2003: I have over 300 cells all in column A but there is no pater to them eg (A3,A7,a24,A26,A56,A77,A101) I need to name the range Reset and set the background color to 37 Pale Blue.
Thank you
Ken
Excel 2003: I have over 300 cells all in column A but there is no pater to them eg (A3,A7,a24,A26,A56,A77,A101) I need to name the range Reset and set the background color to 37 Pale Blue.
Thank you
Ken
Please Login or Register to view this content.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Please Login or Register to view this content.
@snb: as ever, much neater ;-)
Last edited by TMS; 06-25-2011 at 09:25 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks