Help a Novice

[ringle]

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

 

[kkknie]

Change to this:

ActiveCell.FormulaR1C1 = "Yes"
ActiveCell.Offset(1, 0).Activate

Do While ActiveCell.Rows.Hidden = True
ActiveCell.Offset(1, 0).Activate
Loop


K

 

[Al Chara]

What about the following:

ActiveCell.FormulaR1C1 = "Yes"
Do
ActiveCell.Offset(1, 0).Activate
Loop Until ActiveCell.EntireRow.Hidden = False