HI group,

 This is a Great & amazing group in learning excel vba..


*Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)*

*Dim st As String*

*Dim sh As Worksheet*

*Set sh = Sheets("Sheet2")*

*st = Target.Address*

*sh.Activate*

*sh.Range(st).Activate*

*ActiveCell.Value = sh.Name & st*
*End Sub*

I had a doubt regarding the above code.
I had taken a sample code from one of  posts.What exactly does the code in
Brackets mean, and when will this type of code in brackets used.Can any body
explain me in detail with some easily understandable examples..I m a
beginner in excel vba...
Thanks in advance...

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Reply via email to