Hi all
I am currently trying to make a macro in Excel XP to check whether a particular cell contains any data, and if so, add the data to a totals cell.
As the cells are dotted around (although all in the same column) I didn't think it would be pratical to just use normal countif formulae in Excel.
So I turned to our friend VBA, but am unsure how to do it.
The data is only between -2 and +2, and I want to count how many times -2 appears, how many times -1 appears, etc.
The problem is I only want to check certain cells and not the ones in between. For instance, A11, A23, A39, A49 etc.
Any ideas?
I am currently trying to make a macro in Excel XP to check whether a particular cell contains any data, and if so, add the data to a totals cell.
As the cells are dotted around (although all in the same column) I didn't think it would be pratical to just use normal countif formulae in Excel.
So I turned to our friend VBA, but am unsure how to do it.
The data is only between -2 and +2, and I want to count how many times -2 appears, how many times -1 appears, etc.
The problem is I only want to check certain cells and not the ones in between. For instance, A11, A23, A39, A49 etc.
Any ideas?