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