Only show workable columns/rows?

[bpflyr]

I have a worksheet that has ranges A:AG and 1:6000. Is there a way that I can view only those ranges. In other words, I don't need to see AH, AI, etc or 6001, 6002, etc.

Thanks.

 

[dtchan]

Goto the VB Editor - Alt F11.
Select the sheet you want to modify in the vb editor.

In the properties window, goto Scroll Area and put like A1:D1600 for example.

 

[bpflyr]

Thank you!!