Thread: Wrong code?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GBH99 GBH99 is offline
external usenet poster
  
Posts: 28
Default Wrong code?
Hello,

Please can someone point out my error below.

Range("I22").Select
ActiveCell.FormulaR1C1 = "=if(" & ActiveCell.Offset(0, -1) &
"-1500)<0,0,RoundDown((" & ActiveCell.Offset(0, -1) & "-1500)/900,0)+1)"

Cheers

Reply With QuoteReply With Quote