Help with Macro Please

G

Grant Reid

Hi

I have spreadsheet with two worksheets, "Admin" and "Format".

On the "Admin" sheet I have two named ranges. In these ranges I enter values
for ColorIndex and PATTERN which I want use to format a range A6:A10 on the
"Format" sheet.
Assume that my ranges are named as follows;
LineColor contains the value 35
LinePattern contains the value -4125

Can anyone help me cobble together a script that will apply this formating
to the cells A6:A10 in the sheet "Format"

Many Thanks - Grant
 
B

Bob Phillips

Hi Grant,

Not sure that I have the right properties, but

With Worksheets("Format").Range("A6:A10").Interior
.ColorIndex = Range("LineCol")
.Pattern = Range("LinePattern")
End With

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
B

Bob Phillips

Glad I got it right<vbg>

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top