View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Carlee Carlee is offline
external usenet poster
 
Posts: 155
Default error handling message help

Hi there,

I have a macro which enables users to import values into a master log. Each
row inserted into the master log has a unique date.
Question:
I'd like to add some code in which Excel loops through the existing rows in
the master sheet and checks that the date to be inserted doesn't already
exist. if it does exist, display a message which enables the user to
overwrite the existing entry or cancel the import process.

Ideas?

--
Carlee