Perhaps this link can get you on track

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you for the answer Pecoflyer. this does help.

the code that you have provided is working very well but what i need is to highlight also beyond the active cell as shown in the screenshots in my first post. this code highlight only above and to the right of the active cell. what i need is to highlight above, under, left and right of the active cell.

is that possible?

regards

Jamal

Attached Images

Clip_83.jpg (143.1 KB, 16 views)