+ Reply to Thread
Results 1 to 2 of 2

On Error skip a section

  1. #1
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    On Error skip a section

    Hi

    I have some long winded code (all shown below) but that's not the issue at the moment. The problem I have is that on each sheet I copy some detail from there, however if there is no data other than the headers I get an error for the below part of code.
    Please Login or Register  to view this content.
    I've used On Error Resume Next however this then pastes the text below so I need to move the code on to a selected point. So within the below code On Error move paste all of this

    Please Login or Register  to view this content.

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Re: On Error skip a section

    Sorry I've just used On Error Goto and it's all good.

+ 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. Hide a section based on the click of a box in the beginning of the section
    By schmidt1962 in forum Word Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2014, 04:51 PM
  2. Replies: 1
    Last Post: 06-16-2013, 07:36 AM
  3. Error 403 Forbidden - Cannot start new thread in the VBA section
    By aalasley in forum Suggestions for Improvement
    Replies: 6
    Last Post: 04-29-2013, 07:07 AM
  4. Deleting Row Section without Disrupting Formula Range Outside of Deleted Section
    By JeffNYG23 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2013, 09:10 AM
  5. [SOLVED] Skip Section of Code if Filter Returns a Blank
    By tamiso2311 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-11-2013, 12:53 AM
  6. Moving section headings from below section to above section..
    By Fayebaline in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-24-2011, 06:58 AM
  7. move that Row From the Waiting section to the completed section automaticly
    By jjsaw5 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-21-2007, 06:50 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