Hello, I am using the function:
[VBA]Application.WorksheetFunction.Match("Total", Range(Cells(i, 1),Cells(i, 1)), 0)[/VBA]
To find certain cells in my sheet that contains:
April Total, May Total and so on. Is there a way I can find the first one, then simply move on to the next one?
I need to make a few things happen around the cells where these totals are found (and the user will write more total cells as the months go by.)
Thanks!