Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On the bar at the bottom of my Excel
application, it says "Ready" on the left and "NUM" on the right. If I right click on the "NUM" thingie, I can select "COUNT" from a list. This counts the number of cells selected and displays "Count=4" on the same bar. How do I activate the "NUM" thingie and select "COUNT" using VBA? I tried "Record New Macro...", but the recording is blank. (It also doesn't help that I have no idea what the "NUM" thingie is actually called.) I am using Excel 97, but that shouldn't matter. -- Many thanks, Martin Leese E-mail: LID Web: http://members.tripod.com/martin_leese/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Confused about sheets and "Select" vs "Activate" | Excel Programming | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Display "Activate" dialog from sheet navigation context menu | Excel Programming | |||
"Select" and "Activate" failing? | Excel Programming | |||
selection.find shortening the procedure by skipping the "activate" part | Excel Programming |