+ Reply to Thread
Results 1 to 3 of 3

if #N/A dont allow to press refresh button

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    08-08-2012
    Location
    englang
    MS-Off Ver
    Excel 2010
    Posts
    152

    if #N/A dont allow to press refresh button

    Hi guys, maybe somebody can help me?

    What i need is if cell G7 or I7 says #N/A do not allow to press the refresh button or just dont copy anythink, but if these cell contains data work as usual. it is only because the people messing about the report and filling data with the error

    Thanks for help.
    Last edited by intex; 12-04-2013 at 04:26 PM.

  2. #2
    Forum Contributor vamosj's Avatar
    Join Date
    04-23-2004
    Location
    Oregon
    MS-Off Ver
    2010
    Posts
    294

    Re: if #N/A dont allow to press refresh button

    Place this at the top, just before the sheet change.


    If IsError(Range("G7").Value) = True Then Exit Sub
    If IsError(Range("I8").Value) = True Then Exit Sub
    Janos S. Vamos
    Data Systems Technician/Fire Controlman PO1(SW/AW)
    US Navy Retired


    Remember, Record Macro can be your friend for figuring out solutions.

    Good or Bad, let me know how I did by clicking on the "Add Reputation" * just to the lower left of here. it only takes a few seconds to let someone know.

  3. #3
    Forum Contributor
    Join Date
    08-08-2012
    Location
    englang
    MS-Off Ver
    Excel 2010
    Posts
    152

    Re: if #N/A dont allow to press refresh button

    Thanks it worked like a charm

+ 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. [SOLVED] How to add the press effect of a button?
    By TheOllie in forum Excel General
    Replies: 16
    Last Post: 06-07-2014, 05:29 AM
  2. Message box when I press Refresh All button.
    By Reykjavik in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2013, 09:22 AM
  3. VB to Press Web page button.
    By Tortus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-22-2010, 11:07 AM
  4. automate button press
    By giant in forum Excel General
    Replies: 7
    Last Post: 05-15-2010, 04:48 AM
  5. [SOLVED] press button via vb and excel
    By sal21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-19-2006, 08:55 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