running an if, and, then

scorpweb

Board Regular
Joined
Jul 26, 2011
Messages
124
hi,

trying to get a if and / then statement to run

the concept is it checks sheet 1 for the day and if a specific tab is active it will then call a sub.
for some reason it's not workign and i cant figure out why. can anyone help?

Code:
If Worksheets(1).Range("C40").Value = "Friday" And Active.Worksheets("31") Then
Call Button5
Else
If Range("C39").Value = "Friday" And ActiveSheet = "30" Then
Call Button5
Else

this code repeats 5 times. to go to 27 but if i can sort out this obv that will be the same :)
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Should it be

Code:
If Worksheets(1).Range("C40").Value = "Friday" And ActiveSheet.Name = "31" Then
    Call Button5
ElseIf Range("C39").Value = "Friday" And ActiveSheet.Name = "30" Then
    Call Button5
Else
 

Watch MrExcel Video

Forum statistics

Threads
1,122,521
Messages
5,596,648
Members
414,083
Latest member
Mrsash

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top