Navigating in a worksheet

[mikeymay]

I have been wondering what is the best way programatically to navigate around a worksheet.

I have, for a few years always used the following example

Do Until Selection = ""
      Selection.Offset(1,0).select
Loop

but recently I have started to use the following

Do Until rngSelection = ""
      Set rngSelection = rngSelection.Offset(1,0)
Loop

The benefits I know of are that you don't need to activate the worksheet in order to navigate around it, fairly useful if you need to pull data from the sheet and drop on a different sheet. But Is the the best way of doing it or is it memory hungry if used on a sheet that holds a lot of data?

 

[mikerickson]

Not selecting is faster and overall better than selecting. Selecting tells the screen to do something, which generally isn't needed in VB routines until they are completed.