+ Reply to Thread
Results 1 to 4 of 4

How to skip blank tabs of cell while using macro

  1. #1
    Registered User
    Join Date
    08-03-2009
    Location
    Banglore, India
    MS-Off Ver
    Excel 2003
    Posts
    8

    How to skip blank tabs of cell while using macro

    Hi,

    I am new to Excel macro programming.
    I have created a macro which copy values from different cell and copy them in append mode to some cell.
    I am able to copy all values but facing problem when there is blank cell between the two cells.
    I have attached the excel file.

    The cell with value problem is not being populated in ADD cell.
    Can any body tell me how to skip the blank cells

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: How to skip blank tabs of cell while using macro

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    02-27-2008
    Posts
    762

    Re: How to skip blank tabs of cell while using macro

    hI
    Try this macro
    ravi
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    08-03-2009
    Location
    Banglore, India
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: How to skip blank tabs of cell while using macro

    Thanks for help

+ 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