Thursday, 15 July 2010

if statement - VBA If-Then Object Required Error -


Based on the code I'm running, trying to change a complex formula by + + =

Currently, cells (5,3). The formula is + (AB2 (Q29) * G29), but I get the error run-time error '424': the required thing when running it In the clock panel, the left (cell (5,3). Formula, 1) returns the "+", and the code breaks if "+" is set to "=" 

  if left (Cell (5, 3) .formula, 1) = "+" then left (cell (5, 3)., 1) = "="   
 Edit: in misspelled No code   
 
 
 This solution will also work:  
  cells (5 , 3). Formula = "=" & amp; Room (5, 3). Formula   
 which will keep  + , but the formula is valid even when starting with  = + .   

 








Posted by



at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)