topic Re: Freeze panes while generating a Excel file using macros in Water Cooler

Freeze panes while generating a Excel file using macros

Anonymous — Tue, 01 Jul 2014 05:39:43 GMT

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 — Tue, 01 Jul 2014 05:46:13 GMT

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 — Tue, 01 Jul 2014 05:49:16 GMT

it is throwing below mentioned error

Select method of Range class failed

whiteline — Tue, 01 Jul 2014 06:01:56 GMT

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 — Tue, 01 Jul 2014 12:32:36 GMT

Can u show any sample how to do that

whiteline — Tue, 01 Jul 2014 14:11:25 GMT

airSheet.Activate