| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2000: Adding column D based on value in column A | Excel Worksheet Functions | |||
| Excel 2000 Column Format not changing. | Excel Discussion (Misc queries) | |||
| Excel 2000 column question | Excel Discussion (Misc queries) | |||
| How do you get different column sizes in one sheet? Excel 2000 | Excel Discussion (Misc queries) | |||
| How do I link data in Excel 2000 from a column to a row? | Excel Discussion (Misc queries) | |||
Linear Mode
