+ Reply to Thread
Results 1 to 2 of 2

Skip blank cell

  1. #1
    Forum Contributor
    Join Date
    05-13-2013
    Location
    Swindon UK
    MS-Off Ver
    Excel 2010
    Posts
    277

    Skip blank cell

    HI

    Can anyone help

    I have a work sheet with data and I copy the data from one sheet to another in different cells, all the data from cells D8,9,10,11,12 & E8,9,10,11,12 go into the travel sheet all works good

    But the problem I have if there is only data in cell D8 it puts the data in the travel form in the correct cell but the data is at the top of the cell and not in the middle, as it is copying all the balnk cells too.

    Can I do at if fuction ie if Blank do nothing?

    Here is the code if anyone can help

    Cheers

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,609

    Re: Skip blank cell

    instead of
    Please Login or Register  to view this content.
    try
    Please Login or Register  to view this content.
    Best Regards,

    Kaper

+ 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. How to get CF formula to skip if lookup cell is blank.
    By Graham Pall in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-02-2015, 09:39 AM
  2. [SOLVED] Return value cannot skip blank cell
    By namialus in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 07-19-2014, 12:12 PM
  3. [SOLVED] Skip/Do not run Macro on the cell if empty/blank
    By Talazem in forum Excel General
    Replies: 3
    Last Post: 11-01-2012, 06:25 PM
  4. VBA to skip if certain cell is blank
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-18-2011, 08:30 AM
  5. Skip Blank Cell and Go To Next Row
    By AnskyCJ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-24-2010, 07:37 PM
  6. How to skip blank tabs of cell while using macro
    By bhagwat in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-03-2009, 06:28 AM
  7. How do I skip a blank cell within macro?
    By DJ Dusty in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-20-2006, 07:20 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