| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
clear pattern but not gridlines
i have a macro that coppies to a sheet & sets col colors.
i have another macro that copies to the same sheet but does not color the colums. i use the ISBLANK(C5)=FALSE statement to set a color if number found for first macro but not used in the 2nd macro. my problem seems to be i have to remove the pattern from the final sheet. the temp sheet is created without a pattern but but is copied to a final that still has colors; how do i clear a pattern off the final sheet but maintain gridlines. thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
clear pattern but not gridlines
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove Pattern Without Affecting Cell Color or Gridlines | Excel Discussion (Misc queries) | |||
| Transfer a name from one cell to another but leave clear if clear? | Excel Worksheet Functions | |||
| clear the clear the web page email attachment lines | Excel Discussion (Misc queries) | |||
| Grey pattern loses gridlines | Excel Discussion (Misc queries) | |||
| In Excel, gridlines won't print--File,PageSetup,Sheet,Gridlines-- | New Users to Excel | |||
Linear Mode
