Excel screen flickering

Article View: comp.apps.spreadsheets

Article #299

Back to comp.apps.spreadsheets Previous Next

#299

From: John Hare
Date: Fri, 22 Jan 1993 22:13

21 lines
971 bytes


  I'm trying to write a macro that copies alot of data around on the
sheet. I would like the user to see a specific part of the sheet while the 
copying is happening. 

  At the moment I goto each cell/block, copy to the clipboard, goto
destination, and paste.  This causes alot of flickering and jumping around
on the screen.  

  Is there a way to copy cells/blocks from one area to another without the
user knowing it's going on?


  Thanks in advance!
  hare@cae.wisc.edu
-- 
      _    _
     | |  | |
     | |__| |       hare@cae.wisc.edu
   /          \     Apps Suport Staff

Technical Details

Message-ID: <1993Jan22.161322.2887@doug.cae.wisc.edu>

Path: arc1-ca.pugleaf.net!sparky!uunet!zaphod.mps.ohio-state.edu!saimiri.primate.wisc.edu!doug.cae.wisc.edu!hare

Show Full Headers

Complete Article Headers

Newsgroups: comp.apps.spreadsheets
Path: arc1-ca.pugleaf.net!sparky!uunet!zaphod.mps.ohio-state.edu!saimiri.primate.wisc.edu!doug.cae.wisc.edu!hare
From: hare@snake-1.cae.wisc.edu (John Hare)
Subject: Excel screen flickering
Distribution: usa
Date: 22 Jan 93 16:13:22 CST
Message-ID: <1993Jan22.161322.2887@doug.cae.wisc.edu>
Originator: hare@snake-1.cae.wisc.edu
Lines: 21