Hi RON!
Sorry it was a long night and I kept working at both options until I sorta
understood them and got one of them to work!
Thanks for the help!
Greg
"Ron de Bruin" wrote in message
...
Hi Greg
I see you got it working with Bob's code
--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl
"Greg Liber" wrote in message
...
thanks for the info... but yup need some help with the rest of what you
said
to do... sorry I don't want to impose.
Greg
"Ron de Bruin" wrote in message
...
Hi Greg
You can use the Counta function to check if all the cells have a value
If Application.WorksheetFunction.CountA(Range("V9:V13 3")) < _
Range("V9:V133").Cells.Count Then MsgBox ""
You can use the beforeclose event to check the above and use Cancel =
true
if not
all the cells have a value
Post back if you need help with that
--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl
"Greg Liber" wrote in message
...
First off I really need to thank Frank, Tom and Ron! While some of
the
others here have also helped out, these three have really stood out
when
answering my questions! You're help has been amazing! Your
patience
with
the rest of us is very remarkable and much appreciated! Thanks for
taking
your time to help us out!
Now to the question...
I want to write a macro that checks column "V" (or range "V9:V133")
on a
payroll worksheet and then if there is nothing in a cell, the macro
returns
a message asking if this is correct... and then allows the user to
change
the cell(s) and continues to check until the entire range has been
checked.
There might be instances of "0" hours so it's OK to have "0" but not
a
blank
in the cell.
In the perfect world... the process would only check for the
information
in
the range "V9:V133" that had information in range "A9:A133"
This is probably pretty easy but I'm not clear as to how to figure
this
one
out... especially with the message box(es) that I would need to
create...
All this because I have users who forget to put in total hours for
employees
on a worksheet... ohh wellll
I'm not sure if this can even be done... but any suggestions would
be
great!
Thanks in advance for any and all assistance!
Greg