Hi,
I want to create a macro that can check each the data of each cell to make sure it is a number before summing them .
eg sum cells a1-a20 and check if each cell has a number in it.
I know how to create a if statement but not to check on all cells with a macro.
I want to create a macro that can check each the data of each cell to make sure it is a number before summing them .
eg sum cells a1-a20 and check if each cell has a number in it.
I know how to create a if statement but not to check on all cells with a macro.