vdennis
Member
Good afternoon all. I am trying to figure out how to read the sheet tab name in a workbook where the number of sheets may vary. What I want to do is to 'trim' the names so in a case if I am looking for "JULY16", and the sheet name it "JULY16 " (notice the space,) it wont crash the program. Yes, that difference did crash the program and it took us hours to figure it out, as some time it would work, and other not. Reason? Different months!
As always, many thanks!
-Dennis-
As always, many thanks!
-Dennis-