Hi, thanks for your response and also I did find your code worked and very useful, I am not sure why you suspect my sheet will be a different name each day, reading my last post the vba example clearly shows that all my macros remains a constant. Anyways, this workbook will be a constant named (Daily Fin_Exports) and the workbook name will always be named "Daily ExAccounts", hence as I explained earlier with the multiple if else/s.otherwise none of my multiple macros would work with the users.If TheWorksheetname = "Exported Account1234 - " Then
Many thanks in advance once again for taking the time to even look
Reply With Quote