Is this overkill?

**Bill Carson** · 10-10-2018, 11:45 PM

Is using .Clean(Trim(StmtStartDate)) in every instance too much? Does it affect performance appreciably?

With Application.WorksheetFunction

Please Login or Register  to view this content.

**¯\_(ツ)_/¯** · 10-10-2018, 11:48 PM

If the variable has already gone through a .Clean(Trim( barrage, there's no need to do it again within the code. It probably doesn't add much overhead to that small bit of code and a small/medium data set, but it's not necessary.

Also, be sure to put your code between CODE tags in the future. You can type CODE and /CODE enclosed in brackets (the first before your code, and the latter after it), or you can press the # button in the text-editor toolbar to insert the tags.

**Bill Carson** · 10-10-2018, 11:55 PM

Thank you. And thank you for the advice.

**AliGW** · 10-11-2018, 01:14 AM

I have done it for you this time, but in future please use code tags (see forum rule #2).

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

PS Unless you are a time traveler, I think the version of Excel in your profile is incorrect ... Please change it.