Can someone please help a novice?
I have a button on my spreadsheet that when clicked activates the following macro:-
ActiveCell.FormulaR1C1 = "Yes"
ActiveCell.Offset(1, 0).Activate
Simple eh?
The "yes" is inserted into a filtered list but the cursor advances to the next cell which may be hidden. I want the next active cell to be the next visible cell. I've seen some posts on this subject but can't work out the exact code that I should use.
Can someone please spare 30 secs to put me out of my misery?
Thanks
I have a button on my spreadsheet that when clicked activates the following macro:-
ActiveCell.FormulaR1C1 = "Yes"
ActiveCell.Offset(1, 0).Activate
Simple eh?
The "yes" is inserted into a filtered list but the cursor advances to the next cell which may be hidden. I want the next active cell to be the next visible cell. I've seen some posts on this subject but can't work out the exact code that I should use.
Can someone please spare 30 secs to put me out of my misery?
Thanks