Extremely simple macro wont work

The error is that in B2 you have a value
Your If statement is testing for text

Sheet1("B2") = "4"
is not the same as
Sheet1("B2") = 4

another suggestion

If B1 is always displays todays date and B2 always displays the Weekday number of todays date why not use this line of code

If Weekday(Now()) = 4 Then Application.Run ("MTEmailer")

Thanks for your suggestion, I have tried it with and without the quotation marks and neither work... I will try the other piece of code and see how that goes.
Cheers
Tane

Hi there,
I tried the suggested formula but nothing happened... considering this one didn't work and my one above didn't either am I putting it in the right place? Something is just not right, both the above codes should work but its just not activating them when I open the workbook when it should be!!!???? Maybe I should just throw it out the window, at least that will make me feel better.

Ok, I got it going by changing the 4 to 5!? Considering its Thursday where I am 5 should be Friday but it activates on thursday... is there a variable that tells me what day of the week is 1, 2, etc.. ??

Try this VBA code

MsgBox Weekday(Now()) this gives the same result as using =WEEKDAY(B1,1) formula

Sunday = 1
Monday = 2
Tuesday = 3
Wednesday = 4
Thursday = 5
Friday = 6
Saturday = 7

Which is a different result you get from using =WEEKDAY(B1,2) on a spreadsheet.

I have never used the Weekday formula and was not aware that you alter the result based on the ,2