On Thu, 25 Sep 2008 21:11:26 -0700 (PDT), Madiya wrote:

I have to do lot ofselection and check sum and count.
Status bar in excel shows sum and count one at a time.
Is there a way, status bar shows sum and count both?

Regards,
Madiya

Madiya,

You can try something like this (put the procedure in your worksheet's
code):
---
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Application.StatusBar = "Sum=" & _
Str(Application.WorksheetFunction.Sum(Target)) & _
"; Count=" & _
Str(Application.WorksheetFunction.Count(Target))
End Sub
---

HTH

B.