Can VBA read the row-col location of a selected cell?

[news.bcentral.com]

I am trying to assign the row and column of a selected excel cell to a
variable name, then return from the VBA procedure to the cell directly below
that cell...without much luck.
Can anybody help?
Thanks...James Hill

 

[david.carl]

Hi

selection.row and selection.column will give you the information you need
Anyway, you can reach the cell below by writing the instruction below if you
are on the activecell

activecell.offset(1,0).select

Regards

 

[Tom Ogilvy]

Dim rng as Range
Dim rw as Long, col as Long
Dim sStr as String

You can set a reference to the cell,
set rng = ActiveCell
rng.offset(1,0).Select
You can use two variable to hold the row and column
rw = ActiveCell.Row
col = activeCell.Column
cells(rw+1,col).Select
You can use one variable to hold the address.
sStr = ActiveCell.Address()
Range(sStr).Offset(1,0).Select

Or if you just want to select the cell below

ActiveCell.Offset(1,0).Select

 

[Guest]

try using the .offset property

Example:
Dim Cell As Range
Set Cell = ActiveCell.Offset(1, 0)

 

[Hari Prasadh]

Hi,

RowNumber = Activecell.row
ColumnNumber = Activecell.column