Ladies & gents,

I'm building a list of addresses in an excel spreadsheet, ie AF3:AG3. I
wish to colour the range of cells calculated. How do I make a macro select
the range listed in that cell?


TIA

Andrew

Hi
if A1 for example stroes the string 'AF3:AG3' try

dim rng as range
with activesheet
set rng = .range("A1").value
end with
rng.interior.colorindex=4


--
Regards
Frank Kabel
Frankfurt, Germany


Andrew wrote:
Ladies & gents,

I'm building a list of addresses in an excel spreadsheet, ie AF3:AG3.
I wish to colour the range of cells calculated. How do I make a
macro select the range listed in that cell?


TIA

Andrew

Range(ActiveCell.Value).Select

selects the range of cells given in the currently selected
cell.

HTH
Helen


-----Original Message-----
Ladies & gents,

I'm building a list of addresses in an excel spreadsheet,
ie AF3:AG3. I
wish to colour the range of cells calculated. How do I
make a macro select
the range listed in that cell?


TIA

Andrew


.