| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to freeze heading rows on a sheet
Hi all:
I'm trying to programatically freeze the heading rows on a particular worksheet via a VBA program. All columns across the sheet should be frozen so that, as I scroll up and down, the headings remain in place. I know this involves a Pane object, but I can't seem to create one programatically. Can someone suggest a way to implement this where the row is variable yet it encompases all the columns? Thanks for any assistance you can send my way! Jon |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Trying to freeze heading rows on a sheet
Hi Jon,
I had trouble doing it without selecting a cell: Sub Freeze_Columns() Dim rVariableRange As Object ActiveWindow.FreezePanes = False Set rVariableRange = Range("a4") rVariableRange.Select ActiveWindow.FreezePanes = True End Sub Hope it helps, JF On 12 Dec, 09:40, JonWestcot wrote: Hi all: I'm trying to programatically freeze the heading rows on a particular worksheet via a VBA program. *All columns across the sheet should be frozen so that, as I scroll up and down, the headings remain in place. I know this involves a Pane object, but I can't seem to create one programatically. Can someone suggest a way to implement this where the row is variable yet it encompases all the columns? Thanks for any assistance you can send my way! Jon |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Trying to freeze heading rows on a sheet
Try something like this:
NoofRowstoFroze = 1 Range("A" & NoofRowstoFroze + 1).Select ActiveWindow.FreezePanes = True Regards, Stefi €žJonWestcot€ť ezt Ă*rta: Hi all: I'm trying to programatically freeze the heading rows on a particular worksheet via a VBA program. All columns across the sheet should be frozen so that, as I scroll up and down, the headings remain in place. I know this involves a Pane object, but I can't seem to create one programatically. Can someone suggest a way to implement this where the row is variable yet it encompases all the columns? Thanks for any assistance you can send my way! Jon |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Trying to freeze heading rows on a sheet
Thanks, Stefi, for the reply. Much appreciated!
Jon "Stefi" wrote in message ... Try something like this: NoofRowstoFroze = 1 Range("A" & NoofRowstoFroze + 1).Select ActiveWindow.FreezePanes = True Regards, Stefi "JonWestcot" ezt írta: Hi all: I'm trying to programatically freeze the heading rows on a particular worksheet via a VBA program. All columns across the sheet should be frozen so that, as I scroll up and down, the headings remain in place. I know this involves a Pane object, but I can't seem to create one programatically. Can someone suggest a way to implement this where the row is variable yet it encompases all the columns? Thanks for any assistance you can send my way! Jon |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Trying to freeze heading rows on a sheet
Hi Joshua:
Thanks for the reply. Much appreciated! Jon "Joshua Fandango" wrote in message ... Hi Jon, I had trouble doing it without selecting a cell: Sub Freeze_Columns() Dim rVariableRange As Object ActiveWindow.FreezePanes = False Set rVariableRange = Range("a4") rVariableRange.Select ActiveWindow.FreezePanes = True End Sub Hope it helps, JF On 12 Dec, 09:40, JonWestcot wrote: Hi all: I'm trying to programatically freeze the heading rows on a particular worksheet via a VBA program. All columns across the sheet should be frozen so that, as I scroll up and down, the headings remain in place. I know this involves a Pane object, but I can't seem to create one programatically. Can someone suggest a way to implement this where the row is variable yet it encompases all the columns? Thanks for any assistance you can send my way! Jon |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Trying to freeze heading rows on a sheet
You are welcome! Thanks for the feedback!
Stefi €žJonWestcot€ť ezt Ă*rta: Thanks, Stefi, for the reply. Much appreciated! Jon "Stefi" wrote in message ... Try something like this: NoofRowstoFroze = 1 Range("A" & NoofRowstoFroze + 1).Select ActiveWindow.FreezePanes = True Regards, Stefi "JonWestcot" ezt Ă*rta: Hi all: I'm trying to programatically freeze the heading rows on a particular worksheet via a VBA program. All columns across the sheet should be frozen so that, as I scroll up and down, the headings remain in place. I know this involves a Pane object, but I can't seem to create one programatically. Can someone suggest a way to implement this where the row is variable yet it encompases all the columns? Thanks for any assistance you can send my way! Jon |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Apply a heading to two different rows | Excel Worksheet Functions | |||
| how can I exclude a heading but show that heading in sheet. | Excel Discussion (Misc queries) | |||
| Consolidate rows & amounts with the same heading | Excel Discussion (Misc queries) | |||
| freeze a heading so it will show on every page as I scroll down | Excel Discussion (Misc queries) | |||
| Excel heading rows to repeat | Excel Discussion (Misc queries) | |||
Linear Mode
