Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need a function that return me how many fields are selected in the current selection now
is it possible?
AFAIK there is no such system function. However, you can achieve that using some expression as I suggested here : Count of Current Selections
Are you looking for this:
=getcurrentselections ( chr(13)&chr(10) , ' = ' )
AFAIK there is no such system function. However, you can achieve that using some expression as I suggested here : Count of Current Selections
with this Expression (based on Thirumalas solution) you get the number fo selected fields
=substringcount(getcurrentselections ( chr(13)&chr(10) , ' = ' ) ,'=')
Hi,
You can use this macro.
Sub Test
set cs = ActiveDocument.GetSheetObject("CS01")
msgbox(cs.GetNoOfRows)
End Sub
Regards,
Kaushik Solanki