Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Why would you want to do that with macro's? They are not supported by Qlikview and it can be done with buttons aswell..
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
Can You give a small Example
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
hey Gysbert i have similar Condition with sheets
if Sheet1 exists then
--------------------
else
-----------------
can you help