Hi Expert,
Please find the attached excel macro enabled file where I've added a Command Button for Saving file Name with Cell value and current date but getting an error message, "Runtime Error 6 overflow" , How to fix it ? another requirement after saving the .xlsx file to Selected path data should be 1. Paste Special with value 2. Saved Sheet Name should be Cell value. Need yours cordial help and advise on this with Sample example as this is my very urgent Task.
Thanks
Porag
Please find the attached excel macro enabled file where I've added a Command Button for Saving file Name with Cell value and current date but getting an error message, "Runtime Error 6 overflow" , How to fix it ? another requirement after saving the .xlsx file to Selected path data should be 1. Paste Special with value 2. Saved Sheet Name should be Cell value. Need yours cordial help and advise on this with Sample example as this is my very urgent Task.
Thanks
Porag