+ Reply to Thread
Results 1 to 7 of 7

How to use select a cell without the action showing on the sheet?

  1. #1
    Registered User
    Join Date
    06-26-2019
    Location
    California, US
    MS-Off Ver
    Office 365
    Posts
    36

    How to use select a cell without the action showing on the sheet?

    I'm using a very simple copy/paste macro. It works fine, but it constantly scrolls my screen up and down when copy and pasting the cells. My screen basically has a seizure for about 10 seconds. Is it possible to freeze the screen I'm looking at or having the macro run without changing the screen at all? This macro strains my eyes a bit whenever it runs.

    Please Login or Register  to view this content.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,318

    Re: How to use select a cell without the action showing on the sheet?

    Maybe try...

    Add at the beginning and the end of the macro...

    Please Login or Register  to view this content.
    HTH
    Regards, Jeff

  3. #3
    Valued Forum Contributor
    Join Date
    07-14-2017
    Location
    Poland
    MS-Off Ver
    Office 2010
    Posts
    528

    Re: How to use select a cell without the action showing on the sheet?

    Hi, test.
    Please Login or Register  to view this content.
    Best Regards,
    Maras.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How to use select a cell without the action showing on the sheet?

    Or ...

    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,114

    Re: How to use select a cell without the action showing on the sheet?

    You could also use
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    06-26-2019
    Location
    California, US
    MS-Off Ver
    Office 365
    Posts
    36

    Re: How to use select a cell without the action showing on the sheet?

    Thank you all!

  7. #7
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,114

    Re: How to use select a cell without the action showing on the sheet?

    You're welcome & thanks for the feedback

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. select data and ask me what action needs to be done?
    By gauti14 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-06-2017, 12:40 AM
  2. Help With Macros – Action (Select Sheet) Based On Cell Value
    By npsnps in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-24-2016, 12:01 PM
  3. Circular reference and what if function showing 0 when I select cell
    By collierm48 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-08-2014, 11:28 PM
  4. [SOLVED] Help With VBA Macro to select cells with certain value and perform action on adjacent cell
    By MSDemocrat in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-10-2014, 03:34 PM
  5. Excel VBA search cell value and select action if the value exist or not
    By Nanouna in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-16-2014, 04:07 PM
  6. Replies: 2
    Last Post: 04-04-2013, 10:32 AM
  7. AutoFill Cell w/ data from different sheet after action
    By ngay528 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2009, 10:58 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1