Formula to format worksheet to numbers and replace empty cells with 0

[vbanovice123]

Hi,

I would like to make my macro work automatically without having to do the below three manual steps:
1) Delete titles, text data and column headers that are text
2) Format the sheet containing percent and text data to number
3) Replace blank cells with 0

I read that there is a way to determine the data type for nulls/empty cells within the sheet as below:

IsEmpty(variable) and IsNull(variable) . Is this so and how can I apply it to the macro.

Also if I need to reformat cells to a number , can I use the format funtion?

The manual steps used above defeats the purpose of the macro as it is not full automated.

Any help is greatly appreciated.

Regards,
Anita

 

[VoG]

As you are only looking at two sheets the code that you have is fine.