I am trying to freeze panes using excel code but it isn't working.
I tried the following codes:
XLDoc.Sheets(LCR).Range("F5").FreezePanes = True
XLDoc.Sheets(LCR).FreezePanes = True
Can anyone tell me what I am doing wrong?
Is LCR the sheet name? If so, it must be enclosed in quotes.
Yes it is the sheet name. This is only part of the code that I pasted in and that is not the problem. The problem lies with the freeze panes.
It works! But can you tell me how I can freeze it at cell F5?
Select cell F5 before executing the freeze panes command.
I got it!
XLDoc.Sheets(LCR).Range("F" & 5).Select
XLApp.ActiveWindow.FreezePanes = True
all in qlikview's vbscript
How to freeze entire first row for me it is working but from 11th line the scroll is enabled
Retrieving data ...