Or ... when using ws functions
.![]()
With Range("D3:G300") .Value = Evaluate("IF(ROW(" & .Address & "),clean(trim(" & .Address & ")))") End With
This will give you a much better performance.
Or ... when using ws functions
.![]()
With Range("D3:G300") .Value = Evaluate("IF(ROW(" & .Address & "),clean(trim(" & .Address & ")))") End With
This will give you a much better performance.
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks