View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mosqui Mosqui is offline
external usenet poster
 
Posts: 10
Default How can I get the value and the format of a cell.

Say I have sheet 1, cell a1 painted red and value 100. In sheet 2 I want to
have the same value and format.
I do =+sheet1!a1, so I get the value, but how I get the color?

Thanks in advance.

Mosqui