| Home |
| Search |
| Today's Posts |
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
code to shade row then return it to as it was
you could change CASE ELSE
Range("3:3").Copy Rows(target.Row).PasteSpecial xlPasteFormats "Jock" wrote in message ... Almost - when "AB" becomes blank again after having a value which coloured the row, how do I get the code to copy row 3 and paste special to the active row (in otherwords, rather than leaving the row with no colour, to copy the colours from row 3). -- Traa Dy Liooar Jock |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| shade one cell that will shade multiple cells | Excel Discussion (Misc queries) | |||
| VBA CODE SOLVER TO RETURN VALUE | Excel Programming | |||
| Return a value for a known code | Excel Worksheet Functions | |||
| Return a value for a known code | Excel Worksheet Functions | |||
| Shade Active Cell - Shade the cell the cursor is in only while in | Excel Programming | |||
Threaded Mode
