Hi guys,
I have a simple macro:
Sub CellValue_Add_1()
ActiveCell.Value = ActiveCell.Value + 1
End Sub
I would like it to automatically move down to the next visible line (its autofiltered, so it can't go to the next hidden line, incase one is there).
Alternatively, I would love my macro to add 1 to all selected visible cells at once - if that is possible.
I have a simple macro:
Sub CellValue_Add_1()
ActiveCell.Value = ActiveCell.Value + 1
End Sub
I would like it to automatically move down to the next visible line (its autofiltered, so it can't go to the next hidden line, incase one is there).
Alternatively, I would love my macro to add 1 to all selected visible cells at once - if that is possible.