One more tip. You can have a combination of Range and cells

set newrange = range(range("A1"), cells(5,10))

which is different from
set newrange = range("A1", cells(5,10))



" wrote:

Ah, but the Range function only accepts Letters. So i could use the
simpler code and change all of my .Range functions to .Cell functions,
since im not actually using them as ranges anyway.

What is best do you think? To work with mycol as a number and use
the .Cell function, or have lots of extra code just to use the .Range
function.

By the way, thanks for your fast response!

-Pogster