Search and replace

[steve_c]

Hi

I would like to create a macro to search all blank cells within a certain range in multiple worksheets to replace it with a certain blank cell. Essentially i would like to use a special values function to do this.

This will help "reset" the cell based on a problem that I'm having with its format.

Any assistance would be great.

Thanks,
Steve

[shg]

Replace blank cells with a certain blank cell's value?

I'm thinking that's a non-event.

Care to explain further?

[steve_c]

Hmm. Is it possible to do this cells which have value in them?

Bascially i would like to run a macro which searches cells in this range where there is 1 to replace it with the value that is in cell B2.

Ie.
A1 B1 C1
1 2 1

[VBA Noob]

Maybe

Please Login or Register  to view this content.

VBA Noob

[steve_c]

Thanks very much

[steve_c]

Hi

In your code below, is it possible to select the same range from multiple sheets. Ie the range of ("A1:C1") from sheet1, sheet2 etc...

Maybe

Please Login or Register  to view this content.

VBA Noob

[VBA Noob]

Maybe

Please Login or Register  to view this content.

VBA Noob