Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Freezing Header Row
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find header then replace header with number of entries below heade | Excel Programming | |||
Omit header from first page without embedding header in code | Excel Worksheet Functions | |||
Excel-Header-My Company Name won't work in Header (AT&T) & Time | Excel Discussion (Misc queries) | |||
Sort - Header:=xlGuess vs Header:=xlNo | Excel Programming | |||
how do I permanetly add custom header to excel header list? | Excel Discussion (Misc queries) |