Results 1 to 5 of 5

Insert and highlight cell when intersect

Threaded View

  1. 07-09-2014, 05:19 AM #2
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Insert and highlight cell when intersect

    Hi,

    You don't necessarily need VBA. See attached.

    If however you want to achieve the same thing with VBA just get VBA to write the function to one cell and copy and paste it to all the rest.
    Attached Files Attached Files
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    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. [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
  2. [SOLVED] Find intersect and replace cell value
    By amar05 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-19-2013, 06:15 PM
  3. Difference between Intersect and Not Intersect is Nothing
    By batman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-13-2009, 05:39 PM
  4. Intersect Operator vs Explicit Cell References and the Dependency
    By Adam in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-29-2005, 12:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1