Freeze panes while generating a Excel file using macros

[Anonymous]

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

[whiteline]

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.

[Anonymous]

it is throwing below mentioned error

Select method of Range class failed

[whiteline]

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.

[Anonymous]

Can u show any sample how to do that

[whiteline]

airSheet.Activate