Hi all,
I use this to toggle from a cell on top of the sheet,
to the cell, one below the last used cell in Col P.

Code
-------------------
Sub TopBottomToggle5()
If ActiveCell.Address < "$G$5" Then
Range("G5").Select
Else
Range("P65536").End(xlUp).Offset(1, 0).Select
End If
End Sub

-------------------
It works as it should. My twist is that, in Column P there may be
pattern in the cells below the last used cell.
The pattern is variable as far as the number of cells below the las
used cell it will populate.
The pattern is put there by another macro, usin
Code
-------------------
Interior.Pattern = xlPatternGray
-------------------
not conditional formating.
I am trying to make the above macro go to the "last used cell in Colum
P which includes if the cell has a pattern in it.
So say, P1:P10 have values and P11:P15 have the pattern, then my activ
cell address should be P16.

Any direction appreciated

--
Desert Piranh

-----------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...fo&userid=2893
View this thread: http://www.excelforum.com/showthread.php?threadid=49111