VBA Code for Worksheet Formatting

Oh!Calcutta

New Member
Joined
Jun 15, 2011
Messages
23
Hi all!

I want to format my worksheets as Cols. A to AZ and Rows 1 to say 3000. Pl help me. I could not locate earlier post(s) on this topic, if any.

Thanks in advance.:LOL:
 

patel45

Well-known Member
Joined
Jul 15, 2012
Messages
1,953
i'm not sure to have undertood well, but try
Code:
Sub a()
Range("A1:AZ1").Value = 3000
End Sub
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Do you mean limit the ScrollArea?

Code:
Worksheets("Sheet1").ScrollArea = "A1:AZ3000"
You can also hide unwanted columns and rows.
 

Oh!Calcutta

New Member
Joined
Jun 15, 2011
Messages
23
Do you mean limit the ScrollArea?

Code:
Worksheets("Sheet1").ScrollArea = "A1:AZ3000"
You can also hide unwanted columns and rows.
Dear Mr Poulsom,

1) Pl explain how to format all 3 sheets (open by default) in any file.

2) Pl also explain how to hide unwanted columns & rows.

Thanks in advance.
Oh!Calcutta:biggrin:
 

Forum statistics

Threads
1,085,309
Messages
5,382,867
Members
401,807
Latest member
xlWatcher

Some videos you may like

This Week's Hot Topics

Top