Possible to write DateAdd output to a cell VBA Macro?

**bkanealy** · 01-16-2015, 03:10 PM

All,

I have an issue with a macro where I'm trying to populate a cell with the results of a DateAdd formula.

This is a monthly report that is ran the 1st of each month.

I'm trying to specify a range to get the Max() of the existing dates for column I and then use the DateAdd to advance it one month. I've attached sample data and the corresponding macro. I'm not sure I'm getting the "rng" populated correctly.

Thanks for any help you can provide.

Brian

**JOHN H. DAVIS** · 01-16-2015, 04:03 PM

Does this help?

Please Login or Register  to view this content.

**bkanealy** · 01-16-2015, 05:04 PM

WOW, that rocks. Thank you soooo much!

**JOHN H. DAVIS** · 01-21-2015, 07:14 AM

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rules and mark this thread as solved.

Possible to write DateAdd output to a cell VBA Macro?

LinkBack

Thread Tools

Rate This Thread

Display

Possible to write DateAdd output to a cell VBA Macro?

Re: Possible to write DateAdd output to a cell VBA Macro?

Re: Possible to write DateAdd output to a cell VBA Macro?

Re: Possible to write DateAdd output to a cell VBA Macro?

Thread Information

Users Browsing this Thread

Similar Threads

Read some data and write some output with a VBA Function

[SOLVED] is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data?

is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data?

[SOLVED] is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data?

[SOLVED] is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data?

Bookmarks

Bookmarks

Posting Permissions