Thread: Problem using Day() in a macro
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Problem using Day() in a macro
Hi,

You don't need to use the Day() worksheetfunction because VB has its own
day() function.

MyDay = Day(MyDate)

Mike

"Marie" wrote:

I am trying to use the Day() function in a macro using a line like this

intLastDay = Application.WorksheetFunction.Day(date as a serial)

But VBA does not seem to recognize Day() as a worksheetFunction
Anybody has an idea why?

PS I am using Excel 2007
--
Marie
Reply With QuoteReply With Quote