+ Reply to Thread
Results 1 to 2 of 2

Run macro only if cell not empty

  1. #1
    Forum Contributor
    Join Date
    11-20-2008
    Location
    UK
    Posts
    132

    Run macro only if cell not empty

    In my workbook cell D3 will sometimes have a member of staffs name in it other times it will be empty.

    I currently have this macro associated to a button in the workbook

    Please Login or Register  to view this content.
    This presently copies a various cells from the workbook into another workbook. This all works fine but I now want to do two things.

    1. When this button is pressed it updates another workbook saying that the job has been completed.
    2. It only performs the above action if D3 is not empty.

    I think I know how to do the former but I can't work out how to do the latter.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Run macro only if cell not empty

    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. macro only run if cell is not empty
    By Pieter in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-10-2014, 06:45 AM
  2. [SOLVED] Macro to copy cell value of Sheet1 to next empty cell of colum A in Sheet 2
    By JamesFinch in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-15-2014, 02:54 PM
  3. MACRO to empty a range of cells based on whether specified cell is empty
    By TBJV in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2013, 10:35 PM
  4. Replies: 1
    Last Post: 10-14-2012, 12:23 AM
  5. [SOLVED] Need a macro to Copy Cell in Sheet1 to the next empty cell in Column A, Sheet2
    By killerthun in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-16-2012, 01:21 PM
  6. Macro, If cell A has data but cell B is empty delete complete row
    By stangz71 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-28-2011, 05:34 PM
  7. Replies: 1
    Last Post: 03-02-2010, 01:23 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