Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Color Index + conditional Formats + validation
I have the following working:
With aWS.Cells(r.Row, r.Column) .Value = oWS.Cells(r.Row, r.Column).Value .Locked = oWS.Cells(r.Row, r.Column).Locked '.Font.Interior.ColorIndex = oWS.Cells(r.Row,r.Column).Font.InteriorColor.Index end with I want to copy the background color index, the conditional format and the cell validation from oWS to aWS. Can someone assist? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying conditional formats | Excel Discussion (Misc queries) | |||
Conditional Format - Copying Formats | Excel Worksheet Functions | |||
copying conditional formats | Excel Worksheet Functions | |||
Copying Abolute formulas and conditional formats | Excel Worksheet Functions | |||
copying conditional formats to a whole column | Excel Worksheet Functions |