Is there a list of commands that excel recognizes and how do I get t
it? I need a method that gets me the row that a cell is in when I tel
it a cell. I don't want to have to keep poasting here for sill
things like this. So where can I look this up

--
Message posted from http://www.ExcelForum.com

-----Original Message-----
Is there a list of commands that excel recognizes and how
do I get to
it? I need a method that gets me the row that a cell is
in when I tell
it a cell. I don't want to have to keep poasting here
for silly
things like this. So where can I look this up?


---
Message posted from http://www.ExcelForum.com/

.
try where strCell is your cell address

range(strCell).select
col_num = activecell.column

nath

Press F2 when in VBA. It gives the object model

As for your question, try:

activecell.row
selection.row



"Spork Rhonewood " wrote in
message ...
Is there a list of commands that excel recognizes and how do I get to
it? I need a method that gets me the row that a cell is in when I tell
it a cell. I don't want to have to keep poasting here for silly
things like this. So where can I look this up?


---
Message posted from http://www.ExcelForum.com/