Hello Raghu, Here is what I came up with. Please change workbook path " E:\Excel\Raghu\ " to the path that...
Hi Hyside2, Basically edit this for loop. If unique(x) <> "" Then 'add workbook Set wb(x) = Workbooks.Add...
Hi Hyside2, Want to change the code, as follows If unique file exists open then Go back to master,...
Dear Sir Thanks for the help. but the result I have got is same. First five columns are not getting...
Not sure how to get rid or the "X" but here is a workaround. If someone clicks on the "X"...
Thanks Hyside2, Will try out and get back to you. Regards Raghu
Hi Raghu, Please try changing the following lines in the code. Line 5 - - Add: gCol As Long From: Dim...
Hello Krishnan, I hope this helps. [img alt_text='' description='']http://vbaf1.com/q/wp-content/uploads/2018/03/followup3.jpg[/img] Sub Macro3() Dim ws1 As Worksheet Dim ws2 As Worksheet Dim...
I’m currently using a toggle button to hide only 1 sheet. I want to creat another toggle button to hide multiple sheets. I’ve tried using an Array but it doesn’t seem to work. I’ll appreciate any help. Thank you.
Please share using the share button above.
If you found the answer is best answer for your question, Please mark as 'best answer' by clicking on the right tick mark icon at the left side of the answer.
Found the answer useful and wants to credit the user, then vote the answer (vote up).
By clicking "Sign up" you indicate that you have read and agree to the privacy policy and terms of service.