Please be more explicit about what you want.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"The Message" wrote in message
...
Hi, I just need help with a simple macro to tranfer two coloumns of
formatted
coloured cells from sheet 4 into sheet 5.

The coloured cells will always by in cells K8 down to K17 (1st column) and
L8 down to L17 (2nd column).

I need these colours transferring to cells AR8 down to AR17 (1st column)
and
AS8 down to AS17 (second column) in Sheet 5.

Is there a simple visual basic code I can use for this macro?

Thanks