N
Nick London
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!
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!