View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
THINKINGWAY THINKINGWAY is offline
external usenet poster
 
Posts: 3
Default Replace a cell (I2) with a cell (H2) if I2 = "a"

I am trying to replace a cell I2 with a cell H2's contents if cell I2 is
equal to the letter a. NOTE: The cell has the letter a preceeded by the
single quote: 'a

It, the single quote, of course is not visible, but when you look in the
formula display box you can see the single quote. Thanks. Also, if this is
code, could you tell me how to inject/insert the code into the excel
spreadsheet and then run it.

Thanks