VBA code adjustment to include only current month and previous month automatically.

Originally Posted by jaslake

Hi Elmer

Please wrap your Code in Code Tags.

Sorry, I thought I did but one of the brackets was messed up.

Hi Elmer,

have not tested yet on VBA, but you can use worksheetfunction.EoMonth.

Formula:

Please Login or Register  to view this content.

Let me know whether it work or not.

Cheers
Lex

Originally Posted by jaslake

Hi Elmer

Not tested...try this.

Please Login or Register  to view this content.

Jaslake, That works great thanks! But for some reason it's not bringing over the right columns and rows for some reason. The range should be columns and rows pertaining to A thru F only. It's bringing over all columns and rows A thru I. Can you help with that?

How can this work correctly ? (2 points before Autofilter)

Please Login or Register  to view this content.

Originally Posted by jaslake

Hi Elmer

Not without seeing your Workbook and just what it is you're trying to do.

On the surface this line if Code makes no sense to me...your placing your Filter starting at Row 4298...

Please Login or Register  to view this content.

And yet you start the Copy of visible cells at Row 2...

Please Login or Register  to view this content.

Thanks again Jaslake, Yes, their demands here are never ending. Your right originally it transferred rows starting at ("$A$4298:$F$14000") to current but now their asking me to isolate automatically the most current month along with the last two years. So it's change yet again on me and I forgot to update the code and my question. What I'm trying to accomplish with my limited knowledge is to transfer Columns and Rows A thru F only for the current month and to also include the last two years.