+ Reply to Thread
Results 1 to 5 of 5

Deselect range

  1. #1
    Forum Contributor
    Join Date
    06-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2016
    Posts
    142

    Deselect range

    Hi, I'm trying to run a macro that is linked to a button run from Sheet4. This macro runs other macros that use table ListObjects in Sheets 1, 2 and 3.

    The problem I'm having is when I run the macro from sheet 4, the entire data body range in each table/sheet is selected.
    And if I run the macro while viewing Sheet1, the table's data body range is not selected, but Sheet 2 and 3's are.

    Note: Nowhere in my coding is a cell selected.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,292

    Re: Deselect range

    Where's the code for RefreshSiteOp, RefreshGarage and RefreshOffice?
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    06-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2016
    Posts
    142

    Re: Deselect range

    Please Login or Register  to view this content.
    Each of those functions are the same, but have different fields/table/areas to import from an Access database
    Last edited by Smally; 11-19-2015 at 07:35 AM.

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,292

    Re: Deselect range

    Where's the code for ImportExpiryTableADO?

    Is there any other code?

    Have you tried stepping through the code when you run it from Sheet4?

  5. #5
    Forum Contributor
    Join Date
    06-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2016
    Posts
    142

    Re: Deselect range

    The rest of the code:
    Please Login or Register  to view this content.

+ 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. Replies: 0
    Last Post: 10-22-2013, 01:04 PM
  2. [SOLVED] Deselect all cells in range except top left cell
    By pkew22 in forum Excel General
    Replies: 2
    Last Post: 07-23-2013, 03:44 PM
  3. Deselect selection if it's not within a defined range
    By Shanthan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-31-2013, 11:10 AM
  4. Function to Deselect after selecting range for sort
    By Patchworks in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-14-2009, 12:47 AM
  5. [SOLVED] find within a named range, then deselect the range
    By Bob Mouldy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-22-2006, 03:25 PM
  6. [SOLVED] .SeriesCollection(2).Name and .Deselect
    By Peter Sie in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-02-2006, 10:15 PM
  7. ActiveChart.Deselect won't Deselect
    By Mark Stephens in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-15-2005, 10:05 PM
  8. [SOLVED] deselect
    By sali in forum Excel General
    Replies: 2
    Last Post: 04-30-2005, 06:06 PM

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