Change ranges fill colour using the colour in another cell

[tonywatsonhelp]

Hi Everyone

Hi everyone

So I'd llike a macro that will fill the range AD15:AZ25
the same colour that cell AD8 is

so i fill cell AD8 with a colour when i run the macro it fill the range in the same colour
please help if you can

Thanks

Tony

 

[Fluff]

How about

Sub tony()
   Range("AD15:AZ25").Interior.Color = Range("AD8").Interior.Color
End Sub

 

[tonywatsonhelp]

Oh Wow,
thats great thanks Fluff

 

[Fluff]

You're welcome & thanks for the feedback.