Macor Needed

[heather]

Green user of excel, yet have manager’s who like cool stuff.

I need a macro that will look at cell E12 of the tab entitled “worksheet” and depending on the value of E12 it will print the tab “A” or tab “b” or tab “c”.

I dug around in the past posts but can’t find it. I think it is an If and else if statement but can’t seem to make it work.

Any help? Thanks.

 

[Al Chara]

It can be done in an if statement, try the following:

If Worksheets("Worksheet").[e12].Value = "A" Then
Worksheets("A").PrintOut
ElseIf Worksheets("Worksheet").[e12].Value = "B" Then
Worksheets("B").PrintOut
ElseIf Worksheets("Worksheet").[e12].Value = "C" Then
Worksheets("C").PrintOut
End If

 

[heather]

That seems to easy. I will give it a try. Thanks!

 

[Jay Petrulis]

On 2002-04-09 11:57, heather wrote:
Green user of excel, yet have manager’s who like cool stuff.

I need a macro that will look at cell E12 of the tab entitled “worksheet” and depending on the value of E12 it will print the tab “A” or tab “b” or tab “c”.

I dug around in the past posts but can’t find it. I think it is an If and else if statement but can’t seem to make it work.

Any help? Thanks.

Hi Heather,

What are the values that are allowed in E12. What criteria determines which sheet?

If all you will place in the cell is "A", "B", or "C" then try:

------------------------
Sub print_choice()
Dim RangeVal As String

On Error Resume Next
RangeVal = Sheets("Worksheet").Range("E12")
Sheets(RangeVal).PrintOut
On Error Goto 0

End Sub
-------------------

If there are other worksheet selection paramters, then please post back.

Bye,
Jay