Same problem.

But instead of using
If Cells(RowCnt, ChkCol).Value = "-"
can I refer to a cell in another sheet by naming it ?

If so, what would the code look like.

THanks
BIll H


"Gord Dibben" wrote:

To run some event code or???

I would say most likely

Give some details


Gord

On Tue, 16 Dec 2008 17:31:02 -0800, Bill H
wrote:

Gord,

THanks for all the help, I've got it working now !

Just a side question, can I reference a cell on another work sheet, or by a
named cell ?

Thanks
Bill H