Condition in Macro

[#1]

hi Guys

can i write the following condition in Macro :

If there is no sheetobjects in a sheet then

------

else

------

Basically i want to check whether there is any sheet object in a particular sheet or not

[#2]

Why would you want to do that with macro's? They are not supported by Qlikview and it can be done with buttons aswell..

[Gysbert_Wassenaar · Accepted solution]

You can use NoOfSheetObjects to get the number of objects on a sheet. If it is 0 then there are no objects.

set s=ActiveDocument.Sheets("Main")

if s.NoOfSheetObjects > 0 then

...do stuff

else

...do other stuff

end if

[#4]

Can You give a small Example

[#5]

I can't reproduce one at the moment, but that's what Qliktech told me and why i don't use Macro's.. If your Macro doesn't work after an update you can't get support on them, while buttons should cover like 99% of the posibilities. Sorry

[#6]

hey Gysbert i have similar Condition with sheets

if Sheet1 exists then

--------------------

else

-----------------

can you help