Results 1 to 13 of 13

Macro to skip header and search for non empty cells

Threaded View

  1. #1
    Registered User
    Join Date
    05-09-2014
    MS-Off Ver
    Excel 2003
    Posts
    9

    Macro to skip header and search for non empty cells

    Hi folks, I am a newcomer here and trying to get to grips with Macros.

    The following macro (supplied by someone else on here) almost does what I need.
    It searches the whole of column C and if it is not empty it will execute another command.

    If Range("C" & ActiveCell.Row) = Empty Then
     MsgBox "Cell A5 is empty!"
     Else
     Call copymacro_name
     End If
    However when I test it this seems to also include the first cell which is part of my data header (the whole of the first row). Is there any way to skip that?

    Also what I want to do is once I find a cell with something in it I wish to create a blank row below it
    For example if something is found in Cell C row 3 insert a new row below it so row 4 is blank.
    Then repeat the search for each cell in column C until I reach the end of the file.

    Is this possible? Anyone have any suggestions?
    Last edited by Fotis1991; 05-10-2014 at 06:59 AM. Reason: PLS USE CODE TAGS AROUND YOUR CODES

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 03-08-2014, 02:03 PM
  2. [SOLVED] Macro to Skip if filtered values are empty
    By Jiptastic in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2013, 05:32 PM
  3. Formula/Macro for copying, skip empty cells
    By joscar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-16-2011, 06:04 PM
  4. Excel 2007 : VLOOKUP skip rows with empty cells
    By cl8390 in forum Excel General
    Replies: 3
    Last Post: 06-28-2011, 03:28 PM
  5. Skip empty cells in vlookup-type application
    By cl8390 in forum Excel General
    Replies: 1
    Last Post: 06-27-2011, 04:01 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