Print Command in Excel 2

[mikes0370]

I have created a workbook in Excel consisting of 4 worksheets. Worksheet1 is an "Instructions" page, Worksheet2 is a "Data Entry" page, Worksheet3 fills with information from the "Data Entry" page and also contains some "user" data entry elements, Worksheet4 is same as Worksheet3. I would like to be able to print Worksheets 3 and 4 at one time using a Print Command Button on the "Data Entry" page once all data is complete. I am "code challenged"...and cannot seem to make sense of the code I have read about. I have read about this in the Excel 2003 Bible and tried to copy code from some of the Q&A websites that I have found. When I run the macro I receive an error that reads "Sub-script out of range" I am sure it is something simple that I am missing. Can someone please help???

 

[SkipVought]

Hi,

Select BOTH tabs--then print. Turn on your macro recorder once you know what you are doing.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[mikes0370]

Thanks Skip! That helped a lot! This is a great resource...I can see using it A LOT from now on. Have a great day!

 

[JPaules]

Mikes0379

Be careful when using that function. It goups the two worksheets together and whatever you add to one speadsheet gets added to both.

--
JP

 

[mikes0370]

Thank you JPaules...I will remember that when making changes.