Help with Macro Please
 

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

Help with Macro Please
 

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)

"Grant Reid" wrote in message
...
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

Help with Macro Please
 

Thanks Bob. Was exactley what I needed.

Help with Macro Please
 

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)

"Grant Reid" wrote in message
...
Thanks Bob. Was exactley what I needed.