Writing '0' to a particular range of cells

[modest_16081982]

Hi,

I have a range of cells named , for example as "test_data". How can I achieve the following:
If the cell is blank then write '0'
else do nothing if the cell has some characters.

Thanks

[VBA Noob]

Maybe

=IF(A1="",0,"Do something else here")

VBA Noob

[shg]

Select the range

Do Edit > Goto > Special > Blanks

Type 0, Ctrl+Enter

[modest_16081982]

Select the range

Do Edit > Goto > Special > Blanks

Type 0, Ctrl+Enter

Great!!! Thanks it worked like a charm....You are awesome. Now the only thing that remains is to somehow write a formula or a VBA code for this.

[VBA Noob]

Please Login or Register  to view this content.

VBA Noob

[shg]

Please Login or Register  to view this content.

[Leith Ross]

Hello modest_16081982,

Just an addendum to Shg's andVBA Noob's last post. When using the SpecialCells method, it will generate an error if no blank cells are found in the given range. If you don't trap the error, your macro will be interrupted. Here's an example of trapping the error if it occurs, and then restoring normal error handling.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[modest_16081982]

Hello modest_16081982,

Just an addendum to Shg's andVBA Noob's last post. When using the SpecialCells method, it will generate an error if no blank cells are found in the given range. If you don't trap the error, your macro will be interrupted. Here's an example of trapping the error if it occurs, and then restoring normal error handling.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Great!!! Thank all of you three guys for helping me out.

You guys rock.

[VBA Noob]

Thanks Leith as usual,

modest_16081982,

Good to see you got a solution


VBA Noob