skip NON blank cells and fill only blanks

[donyc]

Hi all, was hoping someone could help me with below please. I have formulas that I want only to populate BLANK cells.

Below are 2 steps I take(its more than 2 though) and I want to run those formulas, skipping any non blank cells. The 2nd part works by itself, but when I run it together it keeps overwritting each other..

any help would be very much appreciated as I am little lost with this. thanks so much

Please Login or Register  to view this content.

[marreco]

See if this helps you.

Please Login or Register  to view this content.

[donyc]

sorry I am little lost..is c(2) a cell? is there anything I need to take out from my current code

[donyc]

I got someone help me with another option(2nd paragraph), but the problem I run into is that it works fine by itself, but when I run my 1st job below then it doesnt work, the macro just runs through with nothing being populated.. any help would be much appreciated

Thanks so much

Please Login or Register  to view this content.

[TMS]

You could try:

Please Login or Register  to view this content.

Regards, TMS

[donyc]

that did the trick. Awesome! thank you so much! this is now Solved

[TMS]

You're welcome.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save