Home |
Search |
Today's Posts |
#1
|
|||
|
|||
NUMBER OF COMMANDS
Hi,
Can anyone tells me that how many total built in commands are there in excel. Rajeev |
#2
|
|||
|
|||
Hi
Run this macro Sub test() Dim Cbar As CommandBar Dim BCOUNT As Long BCOUNT = 0 For Each Cbar In Application.CommandBars If Cbar.BuiltIn = True Then BCOUNT = BCOUNT + 1 End If Next MsgBox BCOUNT End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "RAJEEV CHADHA" wrote in message m... Hi, Can anyone tells me that how many total built in commands are there in excel. Rajeev |
#3
|
|||
|
|||
do you mean functions like SUM ...
if so then from help (Excel specifications and limits) Number of available worksheet functions 329 the analysis toolpak gives, i believe, an additional 110 -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "RAJEEV CHADHA" wrote in message m... Hi, Can anyone tells me that how many total built in commands are there in excel. Rajeev |
#4
|
|||
|
|||
Hi
My example is for the CommandBars I see you want it for controls (which CommandBar and why ?) -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Hi Run this macro Sub test() Dim Cbar As CommandBar Dim BCOUNT As Long BCOUNT = 0 For Each Cbar In Application.CommandBars If Cbar.BuiltIn = True Then BCOUNT = BCOUNT + 1 End If Next MsgBox BCOUNT End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "RAJEEV CHADHA" wrote in message m... Hi, Can anyone tells me that how many total built in commands are there in excel. Rajeev |
#5
|
|||
|
|||
Number of available worksheet functions 329
Ahaaa Forget my answer(this is not programming <g) -- Regards Ron de Bruin http://www.rondebruin.nl "JulieD" wrote in message ... do you mean functions like SUM ... if so then from help (Excel specifications and limits) Number of available worksheet functions 329 the analysis toolpak gives, i believe, an additional 110 -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ...well i'm working on it anyway "RAJEEV CHADHA" wrote in message m... Hi, Can anyone tells me that how many total built in commands are there in excel. Rajeev |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
putting a number equal to writing commands | Excel Worksheet Functions | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
multiply by actual number in cell | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |