+ Reply to Thread
Results 1 to 8 of 8

If active cell is empty then run macro

  1. #1
    Valued Forum Contributor
    Join Date
    11-27-2013
    Location
    Brooklyn, NY
    MS-Off Ver
    Office 365
    Posts
    1,172

    If active cell is empty then run macro

    Hello.
    Can anyone please take a look at my code and see why it's not executing properly?
    Please Login or Register  to view this content.
    Thank
    Last edited by kosherboy; 05-22-2014 at 10:57 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: If active cell is empty then run macro

    Try wrapping your code in the following worksheet module

    Please Login or Register  to view this content.
    Elegant Simplicity............. Not Always

  3. #3
    Valued Forum Contributor
    Join Date
    11-27-2013
    Location
    Brooklyn, NY
    MS-Off Ver
    Office 365
    Posts
    1,172

    Re: If active cell is empty then run macro

    Sorry, i didn't include that in my code.
    This how my code looks for real:

    Please Login or Register  to view this content.

  4. #4
    Valued Forum Contributor
    Join Date
    11-27-2013
    Location
    Brooklyn, NY
    MS-Off Ver
    Office 365
    Posts
    1,172

    Re: If active cell is empty then run macro

    This is how i modified my code according to your post:

    Please Login or Register  to view this content.

    Let me know i this is correct.

    Thanks.

  5. #5
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: If active cell is empty then run macro

    Deleted. I see now.

  6. #6
    Valued Forum Contributor
    Join Date
    11-27-2013
    Location
    Brooklyn, NY
    MS-Off Ver
    Office 365
    Posts
    1,172

    Re: If active cell is empty then run macro

    Quote Originally Posted by JOHN H. DAVIS View Post
    Deleted. I see now.
    I'm sorry?

  7. #7
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: If active cell is empty then run macro

    No. No need to apologize. It was a mistake I made in reading your code.

  8. #8
    Valued Forum Contributor
    Join Date
    11-27-2013
    Location
    Brooklyn, NY
    MS-Off Ver
    Office 365
    Posts
    1,172

    Re: If active cell is empty then run macro

    I hear.
    Can you help me though?


    In the code i posted i had another code that did the exact opposite, which i did not originally post since i didn't think it was needed, however, i was thinking maybe the codes are conflicting.
    Therefore I merged both codes together:
    Please Login or Register  to view this content.
    Can you see if something needs to be changed?
    Last edited by kosherboy; 05-22-2014 at 12:18 PM.

+ 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. [SOLVED] if workbook inactive for 30sec make last empty cell in column b the active cell
    By sspreyer in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-30-2013, 09:01 PM
  2. [SOLVED] Macro to sort from active cell up to first empty row above and subtotal
    By Stratfordoaks in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2012, 01:28 PM
  3. Selecting an empty cell underneath active cells
    By Frank54324 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-27-2012, 11:54 AM
  4. Copy values from cell in active row, paste in first empty cell in spesified column.
    By Test123Test in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-19-2012, 05:20 PM
  5. [SOLVED] macro- move down to empty cell & active worksheet
    By EducatingMom in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-04-2006, 06:05 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