Login or sign up Lost password?
Login or sign up
They are addressed as List Objects, a collection that was introduced with Excel 2003. Select ' Select just row 4 (header row doesn't count! The code in the following post (due to post size limitations) is intended to change the color of a Wingding dot character in a cell based upon the contents of the adjacent cell. Is the Color Index value only available through List Objects("Table1")? I am new to Excel Macro coding and can't seem to find a reference for the Table object model on the Web or in the Help. ' Written by Ken Johnson 'Check for changes to any of the dropdown cells 4 columns to the right of the Tasks column If Not Intersect(Target, Range("Tasks"). Value Case "Not Started" 'Make the wingding character the same color as the cell interior so that it is not visible With rg Cell.