View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
imoose imoose is offline
external usenet poster
 
Posts: 6
Default Macro to set cell interior color?

I'd like to create a macro that will fill the current cell (or cells) with
whatever the current fill color is.

I tried to record a macro to do this, but it always fills the cell with the
color that was current when the macro was recorded.

Perhaps I could modify that macro in the VBA editor ... but I don't know
what value to use for the color index.

Any help is greatly appreciated.