Thanks Dick!
It is the only way I knew how to do it... is my answer! I now know there is
a different way!
Since I have been using offset, I think I will stay with it!

Bruce

"Dick Kusleika" wrote in message
...
Sue

FWIW, I never use ActiveCell.Offset in my Excel code. I always use
Worksheet.Cells(rownum,
colnum). Is there an advantage to ActiveCell.Offset?

No real advantage that I know. It's just two different way of pointing to
the same Range object. I use Offset because (to me) it's easier to read.

ActiveCell.Offset(1,1).Value

vs.

ActiveSheet.Cells(ActiveCell.Row+1,ActiveCell.Colu mn+1).Value

But it's all a matter of personal preference.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.