In VBA is there way to make a row transparent when it currently has an Interior colour set on it ? Tried the line below but that sets the background to white
Range("B" & rowNUm & ":L" & rowNUm).Interior.ColorIndex = 2
Thanks,
In VBA is there way to make a row transparent when it currently has an Interior colour set on it ? Tried the line below but that sets the background to white
Range("B" & rowNUm & ":L" & rowNUm).Interior.ColorIndex = 2
Thanks,
Range("B" & rowNUm & ":L" & rowNUm).Interior.ColorIndex = xlNone
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks