Replacing Blank cells with Text

[dwhite30518]

Good morning All!!

I am trying to work with the following code...

Please Login or Register  to view this content.

I thought I have declared everything I needed to. However, when I try and run the code, I get an error that states:
Compile Error: Method or data member not found

What did I do wrong? The objective is to replace the blanks in Column Y(named: Problem Reported) with Problem Not Reported. I have different worksheets within the main workbook that consist of different number of rows, so this code need to be able to accommodate that variant.

Please HELP!!!!!

[tom1977]

Hi change Cout into Count

[JapanDave]

You spelt count wrong and you can't declare a variable as a cell, it needs to be a range

Please Login or Register  to view this content.

[tom1977]

It could be even shorter You do not hava to set activeworksheet

Please Login or Register  to view this content.

[JapanDave]

Or...

Please Login or Register  to view this content.

[dwhite30518]

Thank you everyone!!! These worked great!!!

[dwhite30518]

I actually have one more question relating to this...if I wanted to include a Trim function prior to checking for the blanks in this same cell range...what is the best way to do that?

[JapanDave]

Using your code,

Please Login or Register  to view this content.

[dwhite30518]

Yes, that is the code I am using.

[dwhite30518]

There are some cells that have carriage returns in them.

[JapanDave]

There are some cells that have carriage returns in them.

That code uses the trim function. I just used what you were using to demonstrate. Try the code.

Sorry, what is a carriage return?

[dwhite30518]

Take a look into cell A2...this is what I would like to fix. I have cells throughout the column that are like this and I would like to fix this without having to going into the cell and hitting the delete key until it is like the other cells.

[dwhite30518]

I think if I were to add a line to clear the contents of the cell if the cell is blank then this would accomplish the goal....I just am not sure how or where it incorporate that function.