Thread: Freeze pane
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nick London Nick London is offline
external usenet poster
 
Posts: 13
Default Freeze pane

I have a macro in which I want to freeze panes. The problem is that I do not
know how to write it variably. I want to freeze panes in the column where I
find a certain word. The code is:

Set rng2 = Worksheets("Beräkning").Cells.Find("Security ID", LookIn:=xlValues)
......
Columns(rng2.Address).Select
ActiveWindow.FreezePanes = True

The penultimate line is wrong but I do not know how write it. Please help me
out!