Thread: Entering formulas via VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron[_32_] Ron[_32_] is offline
external usenet poster
  
Posts: 36
Default Entering formulas via VBA
Niek,

Ecellent, thankyou very much.

Ron











"Niek Otten" wrote in news:#T$uQhD8FHA.2816
@tk2msftngp13.phx.gbl:

For quotes within quotes, use two quotes
Range("r2").Formula = "=IF(Q2=""w"",(P2*(E2-1)*0.95),-P2)"


Reply With QuoteReply With Quote