Dear Shiv,
I believe seeking help for each set by set of the entire code will not help
you. You should search these keywords in google or other search engines for
explanation. Alternatively, you can connect with the person who has written
this code to understand exactly the reasons/ fundas.
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Tue, Feb 9, 2010 at 9:32 PM, Paul Schreiner <schreiner_p...@att.net>wrote:
> Have you tried looking at the "help" documentation for these functions?
>
> I think the first line SHOULD read:
> NextRow = Application.WORKSHEETFUNCTION.CountA(Sheets(1).Columns("A:A"))
> and it counts the number of non-blank cells in column A of the first sheet
> of a Workbook
> and stores the number in the variable "NextRow"
>
> So, if you have 100 rows of data, NextRow would = 100.
>
> Offset is like "moving" from some cell location a specific number of rows
> and columns.
>
> So: "Set CurrentRow = ..."
> is setting the variable called CurrentRow equal to cell A1 + NextRow rows
> down.
> Cell A1 is row 1, + NextRow (ex. 100) would mean that CurrentRow would be
> row 101, in the same column (A)
>
> Currentrow.Offset(0,0) means to take the current CELL (A101) and move 0
> rows and 0 columns (still A101) and insert "Ability"
> CurrentRow.Offset(0,1) means to start at the current CELL (A101) and move 0
> rows and 1 column (B101) and insert "Bristol"
>
> the Help available in VBA has all of this information readily available.
>
> Paul
>
> ------------------------------
> *From:* Shiv Goel <shivyn...@gmail.com>
> *To:* excel-macros@googlegroups.com
> *Sent:* Tue, February 9, 2010 9:36:13 AM
> *Subject:* $$Excel-Macros$$ Help
>
> NextRow = Application.CountA(Sheets(1).Columns("A:A"))
> Set CurrentRow = Sheets(1).Range("A1").Offset(NextRow)
> CurrentRow.Offset(0, 0) = "Ability"
> CurrentRow.Offset(0, 1) = "Bristol"
> CurrentRow.Offset(0, 2) = "0117 914 9400"
>
> What is the meaning of this code
>
>
>
> --
> Shiv Goel
> 8NBYN060
> ICFAI National College,YNR
> 9416275776
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 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
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,700 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 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
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,700 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
