+ Reply to Thread
Results 1 to 2 of 2

If Range("K" & ActiveCell.Row) = "" Then (ERROR)

  1. #1
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    If Range("K" & ActiveCell.Row) = "" Then (ERROR)

    Good day,
    Just trying to find out what I am missing as this code of mine doesn't seem to see what is there and not:

    Code

    Please Login or Register  to view this content.
    This codes (On my Command Button Click) will search for the matching text in my Column N and add the rest of the information on my Active row...I added a If there is something in my Active Row "K" then add the following procedure. But no matter what I do it will still run the procedure...

    What am I doing wrong? Is it not at the right place?
    Last edited by Excelnoub; 12-08-2013 at 04:14 PM. Reason: Repost Sheet Code

  2. #2
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Re: If Range("K" & ActiveCell.Row) = "" Then (ERROR)

    Sorry Guys Found it here is the full code:

    Please Login or Register  to view this content.
    Last edited by Excelnoub; 12-08-2013 at 06:36 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. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  2. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 AM
  3. Macro Error with code "Range("A65536").End(xlUp).EntireRow.Insert"
    By lukasj13 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-30-2010, 08:48 PM
  4. Error msgs: "Object varible or with block variable not set"; "subscript out of range"
    By menyanthe in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-26-2009, 04:58 PM
  5. Problem using "Cells" in "Range" "400" error
    By johnnywinter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-14-2009, 05:46 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