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
