Ed

Much depends on how much editing has been done by way of ddeleting rows, as
XL does not reset it's UsedRange setting easily.

You could however put, in place of the fixed range

For each mycell in Range("A1:A4")

For Each myCell in Worksheets("Sheet1").UsedRange

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

universal wrote:
Thanks Nick,

That works a treat!

Any ideas how I might handle this in reverse? The users return data
in varying amounts (some have hundreds of rows, while some may only
have a couple).

Maybe the macro needs to determine how far down (how many rows) the
spreadsheet data goes. Or to look towards the data validation columns
already on the right, so that if that range is TRUE/1, the msgbox is
displayed.

Maybe Im looking at this the wrong way though!!

Many thanks,

Ed



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS