Hello
I presume that you will paste data to this sheet. If yes I would use
separate macro for colouring cells using loop above selected range (this
macro can be called using event procedure worksheet_change as belowe- not
tested).
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.
Dear all,
Please help​ on below point...
*Suman Kumar*
On Thu, May 5, 2016 at 1:01 PM, Suman wrote:
> Dear Team,
>
> I'm using below code to change the cell color once value entered but I'm
> unable to use this for MYRNG. I tried to do this with For Each Loop but
> with this loop code