loop through selectioin changing day in date to last day in the month

I need some help with code that will loop through a selection containing dates changing the day of the date to the last day of the month

thanks

Hi

Try

Please Login or Register  to view this content.

If you don't have the EOMONTH function, then install the analysis toolpak addin.


rylo

I tried the code but I don't have EOMONTH function and am unable to install the pac you said is there another way?

HI

Try this one

Please Login or Register  to view this content.

rylo

Thankyou that code worked but i was unable to set the range I tried to get it to change the dates in a range (Z9:Z22) but it continued to change the date out side this range. How do I get it to only do this range?

Hi

Here goes

This will do it for the fixed range you nominated.

Please Login or Register  to view this content.

This will do it for a variable range starting in Z9, and going to the last used cell in column Z

Please Login or Register  to view this content.

rylo

that worked,

thank you