Start the macro recorder. turn the headers off. stop
recording. start recording. turn them on & stop
recording. Now examine the resulting code.

Sub TurnHeaders_OFF()
ActiveWindow.DisplayHeadings = False
End Sub
Sub TurnHeaders_ON()
ActiveWindow.DisplayHeadings = True
End Sub


Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
Can someone tell me how to switch Row and Coumn headers
on and off in VBA?



.