VBA code to click very cell in a column

[Javi09]

I have over 2000 columns with 5 rows, one of the rows has a number and on another row it has either a,b,c,d,e. I want to get the average depending if their row contains a,b,c.. So i could end up with the averages from the ones with a and averages of b, etc. I have a code but it gives me #DV/0! since its not taking the number as a number, the only way for some reason if click the cell of the number and it turns it into a number but I don't want to click though the whole column one by one. Thanks!

 

[rollis13]

Write 1 in a cell and copy it, then select all the cells/range you need (at least the ones that throw #DIV/0!) and then use Paste Special, select Multiply and apply. You can delete the 1.

 

[Javi09]

Thank you!

 

[rollis13]

Thanks for the feedback, glad having been of some help.