I am creating a commission based macro. Unfortunately the commission is based up a account number which does not have any definition. So I need a stop gap for now. I have 36 accounts, so right now I have :
Range("H11:J" & lRow).Select
With Range("H11:H" & lRow)
.Formula = "=IF(A11=<""4z-BBM060"",0,30)"
.Value = .Value
The problem is now my account codes are all over the place. Before those <60 and those above 60 were charged accordingly. As I said I just want to hard code the client codes. But the codes in H11 order will change from day to day