Find Date from Formula in VBA

[mjmcder]

Hi all,
I am a simpleton with VBA and have a question regarding dates in VBA. I have a large financial workbook with many tabs of data, and am trying to compile a management summary report. I have a "processor" tab where I run all of my macro's from. Here on the processor tab, I have the formula =MMM "&FYNum where FYNum is a named cell that contains the Fiscal Year (we don't operate on a calendar basis so this is needed). so the date appears as "Sep 2017", "Oct 2017", etc.

I then have numerous tabs with a bunch of data, and this data is broken out by month end date (utilizing the same formula as above). so columns B, C, D are cost, market value, and gains/losses for a particular product or investment, and above those three columns is the date formula.

When I store the original date value as a variable from the processor tab, I am unable to do a "find" on that value on the data tabs. Does anyone know how to help here...and I really hope this makes sense. Apologies for the confusing description.

Thanks in advance!

 

[Joe4]

I do find it a bit confusing (and am guessing that maybe others do too).
How about walking us all the way through an actual example (letting us know what values are in which cells, etc)?

 

[Joe4]

Re-posted here: https://www.mrexcel.com/forum/excel-questions/1024174-variable-dates-vba.html#post4915274

Locking this one down.