+ Reply to Thread
Results 1 to 2 of 2

Highlight and insert row error

  1. #1
    Registered User
    Join Date
    12-09-2019
    Location
    Guelph, Canada
    MS-Off Ver
    office 365
    Posts
    8

    Unhappy Highlight and insert row error

    I'm trying to highlight and rows with empty cells in column A and insert them to the top of the sheet. This is part of a larger macros. I've had so much trouble with this since I have codes that does what I want it to do independently but does something else when I put it into the larger module.

    It has to be part of the larger module and I cannot use conditional formatting as this is something very specific to our operations in our lab and my boss says so. He won't have it any other way.

    I've attached an example file with details of how it should look vs how it actually looks. Can someone please help me out with this? Thank you.
    Attached Files Attached Files

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Highlight and insert row error

    Hello unmasked_crusader,

    There is a glaring disconnect between what the results should look like, the actual data on the "Data" sheet and what you describe in your post. Please review your post and update it to accurately reflect the data that will be used and the desired results.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

+ 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. Insert and highlight cell when intersect
    By airbatucampur92 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-11-2014, 04:10 AM
  2. [SOLVED] VBA help need to highlight the cells based on the dates and insert respective cell values.
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-24-2014, 11:14 PM
  3. vba to insert new row AND highlight NEWLY INSERTED ROW
    By wanty in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-01-2013, 11:56 PM
  4. Replies: 2
    Last Post: 11-27-2012, 05:55 AM
  5. [SOLVED] Insert Specific Rows and Highlight Others
    By timbo1957 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2011, 07:27 AM
  6. Insert Blank Rows, Sort and Highlight
    By MSchibs in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-31-2009, 05:17 PM
  7. Code error, highlight error, continue to RUN
    By JohnSeito in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-07-2008, 01:29 AM

Tags for this Thread

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