LinkBack URL
About LinkBacks
Hi,
In range f4:f100 active cell value not found in range sheet1.range(d3:d300)
Then highlight the active cell
With worksheet change event
Thank you
Hi,
In range f4:f100 active cell value not found in range sheet1.range(d3:d300)
Then highlight the active cell
With worksheet change event
Thank you
Last edited by HaroonSid; 06-17-2017 at 11:59 AM.
Use Code-Tags for showing your code :
Please mark your question Solved if there has been offered a solution that works fine for you
If You like solutions provided by anyone, feel free to add reputation using STAR *
Can you give an example of the result you want when active cell in sheet "Sheet1" is not in the range d3:d300
"highlight the active cell" in which sheet ?
- Battle without fear gives no glory - Just try
The below code should do what you're looking for, it will work for multiple cells and non-contiguous ranges
As you didn't specific how you wanted the cell highlighted I have changed it's background color to yellow - just swap this line out for an alternative method to highlight the cell, don't forget to also swap out the line to re-set the highlight effect after the Else clause
Please Login or Register to view this content.
absolute perfect and fast code
i big thank to you mr thatandyward
@pci
highlight the active cell of range f4:f100
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks