Run Part of a Code If Q

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

I have a piece of Code (part of several within the same module) that
mails out a spreadsheet, but I only want it to action if the value in
SheetA1 = Monday (A1 will actually be =Now()). If the Value in A1 is
not = Monday I just want to skip over the code and execute the remaing
code.

How would I do that?

Thanks
 
If Weekday(Sheets("Sheet1").Range("A1")) = vbMonday Then
'do something
End If

Hth,
Merjet
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Skip / Execute Macro Q 1
Run Part of a Module Q 1
Stamp a Cell with Time Q 5
selecting a cell 3
Set value of a cell with a dropdown list during run time (C#) 10
dynamic pivot table selection 1
Can Vba workout if a selection is part of a group? 0
Delete rows if time is greater than present time 2

Back
Top