As given, use the .Row property. There's also the .Column property
Useful too are the .Rows.Count and .Columns.Count properties.

For a safe and fast way to copy tables, this is my preferred method...
eg copy a named range from one sheet to another...

DIM Source as Range
DIM Target as Range
SET Source = Thisworkbook.Names.Item("MyList").RefersToRange
With Source
Set Target = _
Worksheets("Sheet2").Range("B2").Resize(.Rows.Coun t,.Columns.Count)

Target.Value = .Value
End with





"KyWilde" wrote:

Is is possible to extract just the row number from a range address...
so I have E185 in a variable, How can I get just the 185 into a different
variable?
Thanks!!