Hi Guys,
I have used conditional formatting on a range of cells which works perfectly when i manually type in values. But when they are copied from another worksheet using VBA code it stops working. Unless I go to each cell and go to edit it, it doesnt even work if i delete the condition and re-enter it.
If I go to the worksheet select the range and copy then go the new sheet and pastspecial (Values only) it works. But the conditional formatting doesn't like it when using VBA.
The different codes I tried which dont work are:
Can any way Help on this as not sure why none of it works as it only happens to this one column.
Cheers
Bookmarks