Results 1 to 3 of 3

Thread: Shorten VBA Code By Removing Redundant Superfluous Code

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #3
    Senior Member
    Join Date
    Mar 2013
    Posts
    107
    Rep Power
    14
    Thank you

    I still have an error when I select Daily Total button on XFLOW A sheet.It still performs the totals but pops up a error message.I think the error could be that both XFLOW B & C sheets are empty of data.
    On the attached sample if the Daily Total button is pressed it will show the error.
    Can the sheets all have the Daily Total option but work independent of each other.Example would be that XFLOW A & B might get data daily but XFLOW C may get data every second or third day..

    Thanks

    Paul
    Attached Files Attached Files

Similar Threads

  1. Excel VBA Code to Add New Sheets
    By cdurfey in forum Excel Help
    Replies: 1
    Last Post: 06-25-2013, 08:05 AM
  2. Removing unused Cell styles - need an efficient code
    By siddharthsindhwani in forum Excel Help
    Replies: 8
    Last Post: 04-15-2013, 07:12 AM
  3. VBA Code to extract subtotals
    By Howardc in forum Excel Help
    Replies: 2
    Last Post: 12-02-2012, 01:15 PM
  4. VBA Code to Extract data
    By Howardc in forum Excel Help
    Replies: 1
    Last Post: 07-24-2012, 11:37 PM
  5. VBA Code to Clear the Immediate Window.
    By technicalupload in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 09-02-2011, 03:04 PM

Posting Permissions

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