Best/fastest way to reference a cell: .cell vs .range

Hey gurus,

I found this: VBA Golden Rules #19: Use Named Ranges Over Cell Addresses. here: http://www.ozgrid.com/forum/showthread.php?t=76234

I'm guessing that means the .cells function is a subroutine of the .range function. Therefore

dim iRow as integer 'row indexiRow = 3with mySheet  .Range("B" & iRow)end with 'mySheet

should be faster than

dim iRow as integer 'row indexiRow = 3with mySheet  .cells(iRow , 2)end with

The string operator ("B" & iRow) to get the named range function seems like it would take longer than using the numerical references in .cells().

Thanks!
Nate

Re: Best/fastest way to reference a cell: .cell vs .range

Quote from AAE;633876

Range Object - Object Model

Found a line in the Object Model:

Quote

Although you could use Visual Basic string functions to alter A1-style references, it's much easier (and much better programming practice) to use the Cells(1, 1) notation.

Thank you for the links in your reply. This is what I needed to know.

Cheers!
Nate