ExcelBanter - Set Windows Freeze Panes

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Set Windows Freeze Panes (https://www.excelbanter.com/excel-worksheet-functions/125258-set-windows-freeze-panes.html)

Sean

Set Windows Freeze Panes

How do I set via code the Windows Freeze frame at C9 and have the
cursor on Cell C9 also

Thanks

John Bundy

Set Windows Freeze Panes

Does this do what you need?
Range("C9").Select
ActiveWindow.FreezePanes = True

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"Sean" wrote in message
ps.com...
How do I set via code the Windows Freeze frame at C9 and have the
cursor on Cell C9 also

Thanks

Sean

Set Windows Freeze Panes

John Bundy wrote:
Does this do what you need?
Range("C9").Select
ActiveWindow.FreezePanes = True

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"Sean" wrote in message
ps.com...
How do I set via code the Windows Freeze frame at C9 and have the
cursor on Cell C9 also

Thanks

All times are GMT +1. The time now is 03:49 AM.