VBA to apply only on blank cells.

**shiva_reshs** · 10-31-2013, 10:27 AM

Hi,

I have below VBA, which I want to apply only to blank cells of that Row.

Please Login or Register  to view this content.

Please Assist.

Thanks

**shiva_reshs** · 10-31-2013, 11:02 AM

I am able to create the code, But why cant i put just value by removing the formula.

Please Login or Register  to view this content.

When Add .Value, it gives me incorrect result

**JOHN H. DAVIS** · 10-31-2013, 12:13 PM

Maybe:

Please Login or Register  to view this content.

**AB33** · 10-31-2013, 12:27 PM

You need to include an error trapping if there are no blank cells.

Please Login or Register  to view this content.

**shiva_reshs** · 10-31-2013, 03:27 PM

Thanks, it solved.

Re: VBA to apply only on blank cells.