View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dpal dpal is offline
external usenet poster
 
Posts: 33
Default Overrighting ( bring to front)

If I have cells A1 though F19 filled with data.
I am looking for a way to put in A20 a word ("shipped") that would cover
what is written in the block of cells.
Similiar to if I was to put in a word art over those cells.

Can't do it with word Art because I am using a "IF" statement linked to
another page so if one cell ="Y" A20 would say shipped.

Do I use a macro for word art.
Can you help?
Thanks
Dpal