Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Excel VBA - Newbie: Auto deleting cell value

I have a range of cells from A1:H1.

I have some VBA code for a macro, which, when conditions are met
results in a '1' appearing in any one of the above range of cells. A
the worksheet is very large and I don't usually look at the top row
it's easy for me to miss these 1's. If I don't notice them and delet
them, future macros won't work.

What I would be really grateful for, is some generic code to add to th
existing code so that the 1 is deleted as soon as the event i
complete. In this way, I won't need to remember to delete the 1 eac
time.

Hope you can help

--
Message posted from http://www.ExcelForum.com

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 196
Default Excel VBA - Newbie: Auto deleting cell value

the 1 is deleted as soon as the event is

range("a1:h1").clearcontents
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Excel VBA - Newbie: Auto deleting cell value

Mark - thanks a lot!

Can I just ask you what the code would be if I simply wanted to clea
the contents of A1?

TIA

--
Message posted from http://www.ExcelForum.com

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
Excel auto deleting zero at start of cell - change? SpclServFrtCo Excel Discussion (Misc queries) 2 November 26th 07 06:08 PM
excel newbie cell update [email protected] Excel Discussion (Misc queries) 1 November 16th 06 02:55 PM
Excel 2002 auto deleting cswasson Excel Discussion (Misc queries) 1 May 23rd 06 01:01 PM
Newbie VBA Question; Deleting minimum value row Paul Edwards Excel Programming 2 April 18th 04 09:19 AM
Newbie question on deleting duplicate rows Phil Horwood Excel Programming 4 November 26th 03 11:38 PM


All times are GMT +1. The time now is 07:09 PM.

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

About Us

"It's about Microsoft Excel"