Hi,
I want to create a list of dates starting in B6 and going down to B33 or B36 depending of the number of days in a month. The "EOMONTH" function works ok in Excel but when I try to use "EOMONTH" in a macro I'm getting run-time error 1004.
Have set a reference to "atpvbaen" in VB editor. I've also tried "WorksheetFunction.EOMONTH" and "Application.WorksheetFunction.EOMONTH" but with no luck.
Problem is with this line:Please Login or Register to view this content.
Grateful for any help on this problem.Please Login or Register to view this content.
Bookmarks