Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to freeze all panes in my four worksheets.i am using the below code to freeze panes in sheet1 code
airSheet.Range("A2").Select
'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
Regards,
Sivaramakrishnan K
Hi.
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 is throwing below mentioned error
Select method of Range class failed
Yes.
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.
Can u show any sample how to do that
airSheet.Activate