Selecting cells from a list

[Andrew]

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

 

[Frank Kabel]

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

 

[Helen Trim]

Range(ActiveCell.Value).Select

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

HTH
Helen