VBA to Fill Blanks Based on Specific Value

[joshag]

Hello,

In a macro I am trying to fill blanks in a column if a specific criteria/value matches in another column. Example... If the cell in column "H" is blank and column "G" contains "Acme" I want to fill the cell in "H" with a value "Error".

I have researched but not found this specific issue.

Thank you,

[mikerickson]

Try

Please Login or Register  to view this content.

[joshag]

Perfect! Sometimes you need that extra push.

Thank you!

[HarryVF]

Hi,

I've finally found this thread after days of searching and I'm trying to do pretty much the exact same thing and the code you've provided works nicely.

However, with mine, it works for about half the records, returning "Free" as it should, but then for the rest it comes back with #NA - any ideas why this may be?

Also, I've got to do this for three separate columns... For example, if column J equals "Free" then all blank cells in columns I, L and M must be filled with "Free". What's the best way to do this?

This is the code I'm using at the moment. Like I say, it works for about 50% of the records - what am I doing wrong? Any help is massively appreciated!

Please Login or Register  to view this content.