Hi
Copy Paste Special Select Format
HTH
John
"The Message" wrote in message
...
I expect there is any easy answer to this but I am basically wanting to copy
the details of one worksheet into another. Using the basic '= Sheet 1! etc.'
works fine for text, numbers and formulas, but does not seem to work for
simply copying a coloured cell from one sheet to another. The cell has no
formula, number or text. It is simply coloured. All efforts so far have not
worked and all I get is a blank cell (not the coloured one I am looking for).
Any help would be greatly appreciated.