Thread: Running code on workdays
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chrisnsmith chrisnsmith is offline
external usenet poster
  
Posts: 96
Default Running code on workdays
What do I need to do to get this to execute only on workdays?

Sheets("Cus Futures").Select
Range(" H9:I50").Copy Range("D9:E50")
Range("F9:I50").ClearContents
'
Sheets("House Futures").Select
Range(" H9:I50").Copy Range("D9:E50")
Range("F9:I50").ClearContents

Reply With QuoteReply With Quote