How to get Row & Column in Excel 2000 VB?
 

For Example, if I was in cell C5, i would like to be able
to assign row = 3 and column = 5. Is there a function in
Excel VB to do that. Currently, I used the absolute
address and I have to parse it to get the row and column
information. Is there a easier way?

Thanks in advance.

How to get Row & Column in Excel 2000 VB?
 

Hi
msgbox activecell.row
msgbox activecell.column

--
Regards
Frank Kabel
Frankfurt, Germany


J wrote:
For Example, if I was in cell C5, i would like to be able
to assign row = 3 and column = 5. Is there a function in
Excel VB to do that. Currently, I used the absolute
address and I have to parse it to get the row and column
information. Is there a easier way?

Thanks in advance.

How to get Row & Column in Excel 2000 VB?
 

rw = ActiveCell.Column
col = ActiveCell.Row

would give you what you describe.

--
Regards,
Tom Ogilvy

"J" wrote in message
...
For Example, if I was in cell C5, i would like to be able
to assign row = 3 and column = 5. Is there a function in
Excel VB to do that. Currently, I used the absolute
address and I have to parse it to get the row and column
information. Is there a easier way?

Thanks in advance.

How to get Row & Column in Excel 2000 VB?
 

Thank you for your help.

-----Original Message-----
rw = ActiveCell.Column
col = ActiveCell.Row

would give you what you describe.

--
Regards,
Tom Ogilvy

"J" wrote in message
...
For Example, if I was in cell C5, i would like to be
able
to assign row = 3 and column = 5. Is there a function
in
Excel VB to do that. Currently, I used the absolute
address and I have to parse it to get the row and column
information. Is there a easier way?

Thanks in advance.


.

How to get Row & Column in Excel 2000 VB?
 

Thank you for your help.

-----Original Message-----
Hi
msgbox activecell.row
msgbox activecell.column

--
Regards
Frank Kabel
Frankfurt, Germany


J wrote:
For Example, if I was in cell C5, i would like to be
able
to assign row = 3 and column = 5. Is there a function
in
Excel VB to do that. Currently, I used the absolute
address and I have to parse it to get the row and column
information. Is there a easier way?

Thanks in advance.
.