Re: $$Excel-Macros$$ Explanation for a code

2015-09-24 Thread Paul Schreiner
Sure!!! I can try. See below: From: Mandeep Baluja To: MS EXCEL AND VBA MACROS Sent: Thursday, September 24, 2015 12:37 AM Subject: $$Excel-Macros$$ Explanation for a code Dear Paul,  Could you please let me know the explanation of this code after for loop as I am unable to under

Re: $$Excel-Macros$$ Explanation

2014-12-05 Thread Vaibhav Joshi
Hi when you perform index function on one row by x columns, result given by excel is in Array.. e.g. put A in cell A1, B in Cell B1 & C in cell C1. Now write this formula in A2, =INDEX(A1:C1,1,0) now goto cell A2 & then press shift + f3, press enter.. see in result you will see {"A","B","C"}, wh

Re: $$Excel-Macros$$ Explanation for VBA

2014-11-13 Thread Vaibhav Joshi
This one is for what you are looking for... http://www.regular-expressions.info/email.html + *I did not do this for you. God is here working through me for you.* On Thu, Nov 13, 2014 at 2:47 PM, Mandeep Baluja wrote: > Please explain the last line !! What's going on in that line what is

Re: $$Excel-Macros$$ Explanation for VBA

2014-11-13 Thread Vaibhav Joshi
Hi Mandeep Check this...https://www.udemy.com/blog/vba-regex/ http://www.macrostash.com/2011/10/08/simple-regular-expression-tutorial-for-excel-vba/ Cheers!! + *I did not do this for you. God is here working through me for you.* On Thu, Nov 13, 2014 at 2:47 PM, Mandeep Baluja wrote: > Pl