Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor

2014-10-28 Thread Ashish Kumar
Hi Vaibhav Bhai, Sheet is working fine. Superb! Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate

Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor

2014-10-28 Thread Nilkanth Raval
Hi Vaibhav Bhai, Working Perfectly. Thanks... Superb...!! You are amazing *Thanks,* *Nilkanth Raval* *+91 900 428 0 428* *+91 808 000 1620* *Think Before You Print.Consider ENVIRONMENT.* *“SAVE TREES, SAVE EARTH” * *“All appears to change when we change!”* On 28 October 2014 11:38,

Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor

2014-10-28 Thread Nilkanth Raval
Hi Vaibhav bhai, Your code is working perfectly but in attached file, your code is not working correctly. can you please look into this? Thanks for your valuable help. *Thanks,* *Nilkanth Raval* *+91 900 428 0 428* *+91 808 000 1620* *Think Before You Print.Consider ENVIRONMENT.* *“SAVE TREES,

Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor

2014-10-28 Thread Vaibhav Joshi
Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Oct 28, 2014 at 1:35 PM, Nilkanth Raval nilkanth.ra...@gmail.com wrote: Hi Vaibhav Bhai, Working Perfectly. Thanks... Superb...!! You are amazing *Thanks,* *Nilkanth Raval* *+91 900 428 0

Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor

2014-10-28 Thread Vaibhav Joshi
Check this.. + *I did not do this for you. God is here working through me for you.* On Tue, Oct 28, 2014 at 3:11 PM, Nilkanth Raval nilkanth.ra...@gmail.com wrote: Hi Vaibhav bhai, Your code is working perfectly but in attached file, your code is not working correctly. can you please

Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor

2014-10-27 Thread Nilkanth Raval
On 26 October 2014 09:06, Ashish Kumar kumar.ashish...@gmail.com wrote: Nilkanth Dear Sir, Thanks for your reply. Exactly i want to *Separate the Worksheets by Tab color convert it into Workbooks.* *Thanks,* *Nilkanth Raval* *+91 900 428 0 428* *+91 808 000 1620* *Think Before You

Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor

2014-10-27 Thread Vaibhav Joshi
For each tab color separate workbook or colored WS in separate WB? Want to copy or move WS? + *I did not do this for you. God is here working through me for you.* On Mon, Oct 27, 2014 at 1:33 PM, Nilkanth Raval nilkanth.ra...@gmail.com wrote: On 26 October 2014 09:06, Ashish Kumar

Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor

2014-10-27 Thread Paul Schreiner
, October 27, 2014 4:03 AM Subject: Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor On 26 October 2014 09:06, Ashish Kumar kumar.ashish...@gmail.com wrote: Nilkanth Dear Sir, Thanks for your reply. Exactly i want to Separate the Worksheets by Tab color convert

Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor

2014-10-27 Thread Vaibhav Joshi
Check this sheet with code under module Move_Same_ColoredTab This will move all same colored sheets to new WB with existing WB name with suffix 1,2 ,3 etc. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 27, 2014 at 1:33 PM, Nilkanth Raval

Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor

2014-10-25 Thread Vaibhav Joshi
what exactly you are trying to achieve? + *I did not do this for you. God is here working through me for you.* On Fri, Oct 24, 2014 at 8:46 PM, Nilkanth Raval nilkanth.ra...@gmail.com wrote: Dear Sir, I need your help in Moving Multiple worksheets by tab color. I write the below code,

Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor

2014-10-25 Thread Vaibhav Joshi
check this: http://www.ozgrid.com/VBA/group-sheets.htm revert if you need help... + *I did not do this for you. God is here working through me for you.* On Sun, Oct 26, 2014 at 1:34 AM, Vaibhav Joshi v...@vabs.in wrote: what exactly you are trying to achieve? + *I did not do this

Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor

2014-10-25 Thread Ashish Kumar
Hi Nilkanth, PFA Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like

$$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor

2014-10-24 Thread Nilkanth Raval
Dear Sir, I need your help in Moving Multiple worksheets by tab color. I write the below code, but gives me an error. Please help me. Sub MoveSheetsbyTabcolor() Dim wsNames() As String Dim wsColor() As Integer Dim ws As Worksheet Dim ind As Integer Dim Oldwkb As Workbook Set