I have ...

Dim c As String
Dim r As Integer

How do I set ...

c = Current Active Column
r = Current Active Row

... so that no matter where the active cell is on the worksheet, these
values will be returned. Is there such a thing a
WorksheetFunction.CountA for Rows and Columns?


--
gradientS
------------------------------------------------------------------------
gradientS's Profile: http://www.excelforum.com/member.php...o&userid=16563
View this thread: http://www.excelforum.com/showthread...hreadid=345777