Macro help to position a freeze pane command

A

AlanN

I have a macro where it filters rows based on a user request. I want to lock
the title rows on the first visible row below row 2 on column J. The problem
I am having is how to instruction the freeze pane command to occur in column
J on the 3rd visible row down. Does anyone have any ideas?

Thanks, Alan
 
D

Doug Kanter

On a scale of 1 to 100, representing expertise in VBA, I'm about a 12. But,
I've always found it educational to record a macro while performing the
actual keystrokes, inspecting the resulting code, and then editing it
appropriately. Sometimes, it requires a book alongside the computer, but a
book should be considered a blessing, like a bottle of excellent wine, or a
beautiful woman.
 
D

Dave Peterson

Why not just freeze the panes using row 2?

It makes it prettier when the user does a Data|Filter|showall (or just filters
 
Top