Results 1 to 7 of 7

Copy the the Interior.Color when a VLOOKUP formula matches using VBA

Threaded View

  1. 03-19-2020, 04:32 PM #1
    JimS
    JimS is offline
    Registered User
    Join Date
    05-25-2004
    Location
    Cleveland, Ohio USA
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    23

    Copy the the Interior.Color when a VLOOKUP formula matches using VBA

    I use VBA to apply a VLOOKUP formula to a Range in the Active Workbook, but now I need to Copy the Interior.Color (in addition to the value obtained by the VLOOKUP) from the cell when the VLOOKUP finds the matching criteria in the Source Workbook.

    Any ideas?

    Thanks for any and all help.

    JimS
    Last edited by JimS; 03-19-2020 at 04:35 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy interior color, font color from one sheet to another
    By Rashidz70 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-24-2019, 03:17 AM
  2. [SOLVED] Cell Interior Color - Copy / Paste
    By Logit in forum Excel General
    Replies: 15
    Last Post: 02-08-2017, 04:51 PM
  3. Copy interior color with no conditional formatting
    By SERRY in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-17-2015, 10:41 AM
  4. Find a duplicate and then use the duplicates interior.color to change cell color.
    By bopsgtir in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-01-2012, 03:54 PM
  5. [SOLVED] Cell background color (interior color) setting not working
    By Martin E. in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-21-2006, 02:10 PM
  6. Need Excel Formula/Function to color cell interior
    By akaster in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-19-2006, 01:35 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1