Discussion board for questions about the Qlik Community, its features, sharing information, general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!
I want to freeze all panes in my four worksheets.i am using the below code to freeze panes in sheet1 code
'XLApp.ActiveWindow.FreezePanes = True
if i use this same code in sheet2 also means it is throwing subscript out of range exception
kindly provide me a solution
It's a VBA question, not QlikView.
You'd better to post it on the corresponding forum.
In addition your post is in the wrong discussion section.
It's because you don't bother yourself to read the VBA for Excel documentation.
You need to Activate the sheet before performing selections on it.