|
|
#1
06-17-2011, 09:08 AM
|
|||
|
|||
use VBA to name a range
Excel 2003: I have a huge range and they are single cells all in Column A but there is no order to them. eg A1,A3,A11,A31,A33,A36,A77 What I want to do is make a macro that names a range and sets that range background color to 37 Pale Blue, but I don't know how to write VBA.
Thank you Ken 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Resizing the Name range
|
derohanes | Excel | 4 | 05-27-2011 03:05 AM |
|
Limit cell range use
|
talkinglens | Excel | 6 | 12-31-2010 08:43 PM |
| Find and Replace within range | anil3b2 | Word VBA | 3 | 12-01-2010 02:35 AM |
| Sort Range | boutells | Excel | 1 | 07-15-2009 03:02 AM |
|
Range Formula
|
aleksandr | Excel | 10 | 05-18-2009 12:14 PM |
Windows XP 
Office 2003
Threaded Mode