Selecting cells from a list

A

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
 
F

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
 
H

Helen Trim

Range(ActiveCell.Value).Select

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

HTH
Helen
 
Top