Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
GaryDK
 
Posts: n/a
Default

Hi RWN,

Try unchecking "Ignore blank" when you set up the validation, assuming
that by "Delete" you mean clear contents.

Gary

  #2   Report Post  
RWN
 
Posts: n/a
Default

Thanks Gary.

Your response showed up at the same time as Debra Dalgleish's.

Problem resolved (see my reply to Debra).

Thanks for your time.

--
Regards;
Rob
------------------------------------------------------------------------
"GaryDK" wrote in message
ups.com...
Hi RWN,

Try unchecking "Ignore blank" when you set up the validation, assuming
that by "Delete" you mean clear contents.

Gary



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
List, Data Validation, unlocked cell, protected sheet..... Kane New Users to Excel 6 July 16th 12 09:11 AM
Cell Validation Simon Shaw Excel Discussion (Misc queries) 5 March 3rd 05 11:51 PM
Validation depends on cell value SteveT Excel Worksheet Functions 2 January 31st 05 06:17 PM
how to add two data validation lists to a single cell? Mike Peter Excel Worksheet Functions 1 December 8th 04 08:22 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 08:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"