VBA to automate formatting

[ChrisS92]

Hello,

I have a particular set of data:

AA
BB
AB
CC
CA
CD
DA
FA
FD
FC

I want to create an if/then statement to delete all values that contain either an "A" or a "D" for purposes of eliminating irrelevant data. Sometimes I'll have more values, sometimes less, but I always want the same conditions for the clean up to apply. What would the code look like?

Thanks in advance!

 

[Rick Rothstein]

No definitely milliseconds (the code took between 39 & 44 milliseconds in total each run with screenupdating on (the array code I used earlier in thread is roughly 5 milliseconds each run slower with screenupdating off (which is about 5 milliseconds faster than having it off)).

Maybe I am misunderstanding what numbers apply to what, but 5 milliseconds is different than to 0.05 milliseconds you posted.

 

[MARK858]

Maybe I am misunderstanding what numbers apply to what, but 5 milliseconds is different than to 0.05 milliseconds you posted.

Oops typo in the original post it is 5 milliseconds (although FastExcel does measure to the second decimal milliseconds)

 

[igold]

Rick & MARK858,

Thanks to both you guys for taking the time to show ways on improving the code that I wrote. You guys can probably tell by the lack of sophistication in my code that I am a relative noob at coding. Rick, you constantly impress me with the way you are able to reduce the number of lines/routines that it takes to accomplish a given task- kudos.

As an observation, I was going through the "Zero Reply Posts" yesterday when I came across the original post in this thread and it had hardly any views and was on one of the last pages probably getting ready to roll off. I saw that it was an easy "do" so I wrote the code. Now look at the attention the post is getting for a very simple request that went ignored for over two days. The dynamics of the board are interesting. The thing that really sticks out is that the OP has neglected to reach out and thank anyone as of yet.

Again, thanks guys, I appreciate all that I learned from this round of posts.

igold