I'm not sure if this is possible but I have been trying to create
macro that would do a COUNTA function on a selected range and displa
the result in a message box
i.e.
Dim Rangea As Range
Dim Resulta As Variant
Rangea = selelected.Range
Resulta = Application.WorksheetFunctions.counta.Rangea
MsgBox Resulta
It doesn't come close to working so can anyone suggest a way o
accomplishing this?
Cheers :
--
Damin
-----------------------------------------------------------------------
Daminc's Profile:
http://www.excelforum.com/member.php...fo&userid=2707
View this thread:
http://www.excelforum.com/showthread.php?threadid=49212