I have a question about Paste Special.
In general I have a column (K2:K160) that is conditionally formated to strike the text out if =not(isblank($L2). So this will go through the range K2 to K160 and check to see if L2 to L60, respectfully, has anything in it. If so it will strikeout the K columns cell.
This works wonderfully
I then have a VB script that is copying K2:K160 one by one and doing a paste special on others cells in this brick chart I have.
The problem is that the paste special isn't copying the format of the K cell, it is copying the conditionally format formula from the K cell.
example:
L15 is empty.
K60 is struck out because L60 has something in it.
my VBA code copies K60 and does a paste special in B15.
B15 is NOT struck out because the conditional format formula was copied instead and L15 doesn't have anything in it.
*I just want B15 to have the absolure format of K60 which is conditionally set by L60.*
Snippet of VBA code:
Range("$k$69").Copy
Range("$c$3").PasteSpecial xlPasteFormats
Range("$k$211").Copy
Range("$c$4").PasteSpecial xlPasteFormats
Range("$k$89").Copy
Range("$c$5").PasteSpecial xlPasteFormats
Range("$k$39").Copy
Range("$c$6").PasteSpecial xlPasteFormats
Range("$k$40").Copy
Range("$c$7").PasteSpecial xlPasteFormats
Range("$k$41").Copy
Range("$c$8").PasteSpecial xlPasteFormats
...
Please help![]()
Bookmarks