If cell matches criteria, add 0000000

[knutfh]

Hi everyone, I'm completely stupid when it comes to VBA.

Here's is some semi-pseudo code for what I'm trying to accomplish.

Please Login or Register  to view this content.

How should I implement this?
It is crucial that it only affects cells that match the if clause.

Your help is really appreciated!

Best regards,
Knut

[zbor]

Do you mean this:

Please Login or Register  to view this content.

[TMS]

Are they leading or trailing zeroes?

If they are trailing zeroes and you still want the cell to be numeric, you could multiply the value by 10,000,000.


Regards, TMS

[knutfh]

Are they leading or trailing zeroes?

If they are trailing zeroes and you still want the cell to be numeric, you could multiply the value by 10,000,000.


Regards, TMS

They are trailing zeroes. I did actually try this solution too, but my main issue is that nothing happens to the cells.

[Winon]

Then do it this way,

Please Login or Register  to view this content.

Hope that Helps.

[Debraj Roy]

One more approach..

Please Login or Register  to view this content.

[TMS]

It might be worth posting a small but typical sample of your data.

Regards, TMS

[knutfh]

Then do it this way,

Please Login or Register  to view this content.

Hope that Helps.

This helped me a lot! I finally understood what I did wrong. Thank you! :-)

One more approach..

Please Login or Register  to view this content.

Whoa! This solution was by far the best with my dataset. It finishes in about 1/18 the time of the first suggestion.

It might be worth posting a small but typical sample of your data.

Regards, TMS

With Debraj's apporach I have found a fitting solution.

Thank you very much everyone! Your help is immensely appreciated.

Regards, Knut

[Debraj Roy]

Glad that you liked it..