Results 1 to 11 of 11

How to Deselect Multiple Ranges on Multiple Sheets After Select & Clear

Threaded View

catnam How to Deselect Multiple... 12-20-2014, 11:22 AM
berlan Re: How to Deselect Multiple... 12-20-2014, 11:35 AM
catnam Re: How to Deselect Multiple... 12-20-2014, 11:50 AM
berlan Re: How to Deselect Multiple... 12-20-2014, 12:02 PM
catnam Re: How to Deselect Multiple... 12-20-2014, 12:26 PM
catnam Re: How to Deselect Multiple... 12-20-2014, 02:12 PM
mikerickson Re: How to Deselect Multiple... 12-20-2014, 12:42 PM
catnam Re: How to Deselect Multiple... 12-20-2014, 12:50 PM
mikerickson Re: How to Deselect Multiple... 12-20-2014, 01:22 PM
catnam Re: How to Deselect Multiple... 12-20-2014, 01:55 PM
mikerickson Re: How to Deselect Multiple... 12-20-2014, 02:03 PM
  1. #1
    Registered User
    Join Date
    03-18-2010
    Location
    Layton, UT
    MS-Off Ver
    Excel 2013
    Posts
    73

    How to Deselect Multiple Ranges on Multiple Sheets After Select & Clear

    Hi All and Happy Holidays,

    I have problem that I've tried various code to solve, but can't seem to get anything to work.
    The copy of code, in attached Word Doc (sorry if this is a problem) is from one of my module in VB Editor.

    All the different ranges are selected on each of the budget sheets ("JAN BUDGET", etc.), then the code clears all data from each range on each sheet.

    However, after the code runs, only the ranges on the "JAN BUDGET" sheet is deselected.
    I suppose because I select A14 on this sheet, as the last line

    But how do I get ranges on all the other budget sheets to also deselect,
    but at the end have cell A14 on JAN BUDGET was the active cell?

    Thanks for your help.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Clear multiple ranges value
    By sourgreen in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-27-2014, 06:53 PM
  2. VBA to clear multiple ranges from list of sheets
    By y0rk1e72 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-07-2012, 10:12 AM
  3. Compiling multiple ranges of cells from multiple sheets into one grand table ?
    By teacher_rob in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-24-2012, 11:42 AM
  4. Clear Multiple sheets
    By kithing in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-22-2010, 01:48 PM
  5. [SOLVED] in charting, how do i select data ranges from multiple sheets, sa.
    By michael in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-06-2005, 11:06 AM

Tags for this Thread

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