Very Simple VBA questions

[Jzelenka]

Hello,

2 very easy requests that I can not remember how to do:

1)Instead of referring to a worksheet by its tab name, I want to refer to the actual sheet. Under the excel objects, you have sheet1(name). I know how to refer to the sheet by its name, but am unsure how to refer to the sheet1 designation so that my code will work no matter what the tab name is.

2) I have done a recorded macro to set up the layout of one of the tabs at the press of a button. The last part of the code that I want it to do is set up the print area to the current region, no matter how many rows are added. I know the code for this is very easy but I can not get it to work...

Thanks!

 

[Aaron Blood]

Hello,

2 very easy requests that I can not remember how to do:

1)Instead of referring to a worksheet by its tab name, I want to refer to the actual sheet. Under the excel objects, you have sheet1(name). I know how to refer to the sheet by its name, but am unsure how to refer to the sheet1 designation so that my code will work no matter what the tab name is.

2) I have done a recorded macro to set up the layout of one of the tabs at the press of a button. The last part of the code that I want it to do is set up the print area to the current region, no matter how many rows are added. I know the code for this is very easy but I can not get it to work...

Thanks!

1. Sheet1.Select

2. ActiveSheet.PageSetup.PrintArea = ActiveCell.CurrentRegion.Address

 

[Jzelenka]

thanks for the help!