Hi

.... (the range will start at B4). I think I need
xldown and right?!

I would say that you'd better start from xldown towards xlup. Just because, if you go the other way round, if there is an empty cell in your range, this will be your last row and you just might half way to the last row...

example of xlup

dim lastr as long
lastr = sheet1.cells(rows.count, 2).end(xlup).row

the number 2 means column 2 or column B.

Pascal Baro
http://multiskillz.tekcities.com/