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
Dear Paul,
Could you please let me know the explanation of this code after for loop as
I am unable to understand the same ??
Sub CombineRows()
'Update 20130829
Dim WorkRng As Range
Dim Dic As Variant
Dim arr As Variant
On Error Resume Next
Set WorkRng = Application.Selection
Set WorkRng = App
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
Function F_concatenaterow_snb(c01)
F_concatenaterow_snb = Join(Application.Index(c01.Value,1,0), "|")
End Function
Is this Index function or other thing. How is it working.???
--
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
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
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
Please explain the last line !! What's going on in that line what is \b ??
etc etc
Set re = CreateObject("vbscript.regexp")
re.IgnoreCase = True
re.Global = True
re.Pattern = "\b[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,6}\b"
Regards,
Mandeep
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? An
