Hello,

I am trying to freeze the first row of an Excel Worksheet using VB. I
have tried many different codes and none of them work, I have been getting
Null Exception Errors. Here is a piece of code that I am trying to use to
freeze the first row.

objxloutsheet = objxloutwbook.ActiveSheet
Dim FP As Excel.Window
objxloutsheet.Range("A1, Z1").Select()
FP.FreezePanes() = True

I am also not sure on how to select the first row in the FP.FreezePanes() =
True line.

Any help would be appreciated, Thanks in advance.

Hi
Try this:
Range("A2").Select
ActiveWindow.FreezePanes = True
HTH
John
"mdup" wrote in message
...
Hello,

I am trying to freeze the first row of an Excel Worksheet using VB. I
have tried many different codes and none of them work, I have been getting
Null Exception Errors. Here is a piece of code that I am trying to use to
freeze the first row.

objxloutsheet = objxloutwbook.ActiveSheet
Dim FP As Excel.Window
objxloutsheet.Range("A1, Z1").Select()
FP.FreezePanes() = True

I am also not sure on how to select the first row in the FP.FreezePanes() =
True line.

Any help would be appreciated, Thanks in advance.

hi
Activewindow.Freezepanes = True
objxloutsheet.Freezepanes = True should work too.

Regards
FSt1

"mdup" wrote:

Hello,

I am trying to freeze the first row of an Excel Worksheet using VB. I
have tried many different codes and none of them work, I have been getting
Null Exception Errors. Here is a piece of code that I am trying to use to
freeze the first row.

objxloutsheet = objxloutwbook.ActiveSheet
Dim FP As Excel.Window
objxloutsheet.Range("A1, Z1").Select()
FP.FreezePanes() = True

I am also not sure on how to select the first row in the FP.FreezePanes() =
True line.

Any help would be appreciated, Thanks in advance.

Thanks for the reply. Freezepanes is not a member of worksheets, I am not
getting this as the error "Public member 'FreezePanes' on type 'Worksheet'
not found." The error occurs when I have the following as the code:

objxloutsheet.FreezePanes = True

"FSt1" wrote:

hi
Activewindow.Freezepanes = True
objxloutsheet.Freezepanes = True should work too.

Regards
FSt1

"mdup" wrote:

Hello,

I am trying to freeze the first row of an Excel Worksheet using VB. I
have tried many different codes and none of them work, I have been getting
Null Exception Errors. Here is a piece of code that I am trying to use to
freeze the first row.

objxloutsheet = objxloutwbook.ActiveSheet
Dim FP As Excel.Window
objxloutsheet.Range("A1, Z1").Select()
FP.FreezePanes() = True

I am also not sure on how to select the first row in the FP.FreezePanes() =
True line.

Any help would be appreciated, Thanks in advance.