Return Cell(row_pos, col_pos)

[Guest]

Hi everybody

I am new for Excel macro, kindly tell which function can return the row number (y_pos) and the column number (x_pos)

Can answer be found in the Macro help

Thanks!

 

[Tom Ogilvy]

msgbox "row: " & activecell.row & vbNewline & _
"col: " & activeCell.column

--
Regards,
Tom Ogilvy

Hi everybody,

I am new for Excel macro, kindly tell which function can return the row

number (y_pos) and the column number (x_pos).