kire001
06-28-2018, 04:14 AM
Hi there,
I have the following code from the web for clean trim range. I just don't understand why is there a condition using ROW ( "IF(ROW(") and how it works. Appreciate any help. Thanks!
r.Value = Evaluate("IF(ROW(" & r.Address & "),PROPER(TRIM(CLEAN(" & r.Address & "))))")
I have the following code from the web for clean trim range. I just don't understand why is there a condition using ROW ( "IF(ROW(") and how it works. Appreciate any help. Thanks!
r.Value = Evaluate("IF(ROW(" & r.Address & "),PROPER(TRIM(CLEAN(" & r.Address & "))))")