VBA Code for Worksheet Formatting

[Oh!Calcutta]

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.

 

[patel45]

i'm not sure to have undertood well, but try

Sub a()
Range("A1:AZ1").Value = 3000
End Sub

 

[Andrew Poulsom]

Do you mean limit the ScrollArea?

Worksheets("Sheet1").ScrollArea = "A1:AZ3000"

You can also hide unwanted columns and rows.

 

[Oh!Calcutta]

Do you mean limit the ScrollArea?

Worksheets("Sheet1").ScrollArea = "A1:AZ3000"

You can also hide unwanted columns and rows.

Dear Mr. Poulsom,

Thank you very much for your prompt help.

Oh!Calcutta

 

[Oh!Calcutta]

Dear patel45

Thank you!

 

[patel45]

tell us please what did you mean for Worksheet Formatting

 

[Oh!Calcutta]

Do you mean limit the ScrollArea?

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