Thread: Delete the contents of a cell under multiple conditions
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] mrlanier@hotmail.com is offline
external usenet poster
  
Posts: 63
Default Delete the contents of a cell under multiple conditions
If cell A1=1, A1=3 or A1=5, I want the existing contents of B1 to be
deleted. However, if A1=2 or A1=4, I want to be able to enter input
into B1. Can someone suggest a macro for this? Thanks.

Michael

Reply With QuoteReply With Quote