Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to freeze panes using excel code but it isn't working.
I tried the following codes:
1.
XLDoc.Sheets(LCR).Range("F5").FreezePanes = True
2.
With XLDoc.Sheets(LCR).Range("F5").Select
XLDoc.Sheets(LCR).FreezePanes = True
end with
Can anyone tell me what I am doing wrong?
Thank you!!!!
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
Thank you!!!
Hi ,
How to freeze entire first row for me it is working but from 11th line the scroll is enabled
Regards,
Siva