Conditional Formatting Issue With the Range Property
Hi Experts,
using vba code can we fix the range of cells
example : Range("H12:J12") is working fine for conditional formatting.
Issue: when i add a row above this, my conditional formatting is still applying to the same range. Is there any solution to fix the range as Range("$H$12:$J$12"). Please help me in fixing this issue.
Use a named range rather than an address.
Remember what the dormouse said
Feed your head
Hi Romperstomer,
Thank You. Issue Resolved.
Glad to help.
Please mark the thread solved using the Thread Tools link.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks