conditional formating
Range("A1").Copy
Range("B1").PasteSpecial Paste:=xlPasteFormats
and
Range("A1").Copy Range("B1")
Range("B1").FormatConditions(1).Delete
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Miri" wrote in message
...
how do i copy conditional formating from one cell to other(in code)?
another question: how do i copy cell (or cells) without conditional
formating but with all others(formula, formats, values) (in code)
--
--
Miri Tz.
|