If the current month is "Jan-2012" in my system calender.
Now if i run the code,I will get
Current Month : Jan-2012(I have the sheet Jan '12)
Previous Month : Dec-2012 (But we need to get like Dec-2011)(and i don't have that sheet(Dec '11) in my workbook)
If my workbook doesn't have Dec '11 sheet.Then the previous month should not load.
How can i resolve this problem?
---------- Post added at 05:04 PM ---------- Previous post was at 04:54 PM ----------
This is what i am using the code for that
I think now i clear the problem.