I need help With this first line, can anyone see why its not working?
ActiveCell.FormulaR1C1 = "=IF(RC[-2]=""0"",""100%"",=(RC[-3]/RC[-2]-1))"
Range("F5").Select
Selection.AutoFill Destination:=Range("F5:F350"), Type:=xlFillDefault
Thx if anyone got any answers!
Get rid of the 2nd = in the formula.
If posting code please use code tags, see here.
Maybe this.
Please Login or Register to view this content.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
Thx, I combined both of Your two tips !
Thanks for the rep. points.
Please click the Thread Tools drop down box above your first post and choose solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks