find row
 

Good Day,

This is not working;

z = Application.WorksheetFunction.Row(ActiveCell)
MsgBox z.

How to find the row number of the ActiveCell by code?

Thanks for any help.

Brgds

CG Rosén

find row
 

CG,

Try

Dim R As Long
R = ActiveCell.Row

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"CG Rosén" wrote in message
...
Good Day,

This is not working;

z = Application.WorksheetFunction.Row(ActiveCell)
MsgBox z.

How to find the row number of the ActiveCell by code?

Thanks for any help.

Brgds

CG Rosén

find row
 

On Sat, 01 Nov 2003 10:45:46 GMT, "CG Rosén"
wrote:

msgbox ActiveCell.Row

Good Day,

This is not working;

z = Application.WorksheetFunction.Row(ActiveCell)
MsgBox z.

How to find the row number of the ActiveCell by code?


---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *