View Single Post
  #2 (permalink)  
Old 26th June 2009, 02:19 PM
Joel
Newsgroup Contributor


My Top Tip Count:

 
Posts: n/a
Chats:
Default RE: DisplayAlerts = False not working for cell overwrite

------ Register to get rid of these "In Post" ads! ------


Since you are overwriting the data in the same location clear the old data
before writing the new data

ActiveSheet.Range("$FV$34").CurrentRegion.Clear

or
ActiveSheet.Range("$FV$34").CurrentRegion.Clearcontents


"iperlovsky" wrote:

> I have the following code for which I continue to receive a cell overwrite
'Original Source: The Code Cage Forums http://www.thecodecage.com/forumz/excel-vba-programming/110425-displayalerts-false-not-working-cell-overwrite.html#post395364
> prompt despite my insertion of Application.DisplayAlerts = False. Any
> suggestions?
>
> Sub Histo()
>
> Application.DisplayAlerts = False
>
> Application.Run "ATPVBAEN.XLA!Histogram", ActiveSheet.Range("_01"),
> ActiveSheet.Range("$FV$34"), _ , False, False, False, False
>
> Application.DisplayAlerts = True
>
> End Sub
>

Reply to this post


Did you find this post helpful? Yes | No