replace non empty cells of text with zero

[excel01noob]

Hi

I have an excel file report that I need to check daily.
In that file I have some columns with numbers but some cells do not show any number. They should show zero, but when doing ISBLANK they should as FALSE (not blank then)

I want to create a Macro that:

-checks within the columns E8 and F8 (it is always the first cell with numbers) and until the end of the data in those columns (which varies each day);
-all the cells that are NOT NUMBER but also NOT BLANK and;
-replace the content with the number zero.


I'm sure this is feasible but personally tried record macros and could not get the proper result.
any idea how it should be?

thank you in advance

 

[Rick Rothstein]

Without being able to see the file, we can only guess at a solution. Here is my guess...

Sub ReplaceBlanksWithZeros
  Range("E8", Cells(Rows.Count, "E").End(xlUp)).SpecialCells(xlConstants, xlTextValues).Value = 0
  Range("F8", Cells(Rows.Count, "F").End(xlUp)).SpecialCells(xlConstants, xlTextValues).Value = 0
End Sub

 

[excel01noob]

Dear Rick

It worked perfectly, thank you very much!!!