+ Reply to Thread
Results 1 to 2 of 2

Macro copying text to new sheet - getting it to ignore formulas that return blank cells?

  1. #1
    Registered User
    Join Date
    12-24-2008
    Location
    London, England
    Posts
    11

    Macro copying text to new sheet - getting it to ignore formulas that return blank cells?

    Hello all,

    So thanks to some wonderful help from other members of the forum I got the below code working which copies a bunch of text from one of my sheets to another in preparation for it getting printed.

    Please Login or Register  to view this content.
    Now where this code looks there is a formula that works out if data needs to be copied from another cell. If there is data then it copies it across and the code above will then copy it to the new page when run. My problem lies when there is no data to copy. The formula returns a blank cell however the above code still copies the empty cell to the new page. Resulting in the Output sheet having lots of empty spaces at the end of each copied column.

    My question is, is there a way I can get the above code to ignore certain values.

    Please see the attached workbook for an example. What I would like to see on the Output sheet was just the cells that had text in them and not the spaces between.

    Thanks in advance for any help anyone may be able to give.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    12-24-2008
    Location
    London, England
    Posts
    11

    Re: Macro copying text to new sheet - getting it to ignore formulas that return blank cell

    Is this not something that can be done?

    If not could anyone think of a better way of achieving the result?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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