Thread: Writing a formula into a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dr. Schwartz[_3_] Dr. Schwartz[_3_] is offline
external usenet poster
  
Posts: 10
Default Writing a formula into a cell
How should the code look like if I want my macro to enter a formula into a cell.

Example
Cell A1 is empt
I run my macro
Cell A1 contains the formula: =IF(B1="";"Ok";""

Any help is appriciated, thank you
Schwart

Reply With QuoteReply With Quote