yep, just a for next loop which checks whether the first character in a cell is an equal sign.
or, if you know what range of cells are going to have data in them, either enumerate through them, or assign them a "range name", and just clear that. -----Original Message----- From: Cameron Crum [mailto:[EMAIL PROTECTED] Sent: Thursday, 18 September 2003 11:36 AM To: Belinda Scot Cc: [EMAIL PROTECTED] Subject: Re: MI-L Simple Excel Question - quite frustrating You could write a macro that only deletes the "Entry" cells. Cameron Belinda Scot wrote: > Hi Listers... > > I've got a minor problem with excel and I can't seems to find the answer > after trying the help menu and the web. > > I have a data entry worksheet in my application that I need to erase between > uses. However, it has many formulas and I don't want to clear these. How can > I clear the values entered by the user without affecting my formulas? I > would prefer a 'ERASE DATA' button on the spreadsheet. > > Really appreciate any help I can get.. sorry that this is not mapinfo > related... > > :o) Bel... (QUITE URGENTLY NEEDED!!!) > > _________________________________________________________________ > Chat via SMS. Simply send 'CHAT' to 1889918. More info at > http://ninemsn.com.au/mobilemania/MoChat.asp?blipid=6800 > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > Message number: 8422 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8423 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8424
