Hello experts,
I made a table that looks something like this:
A 1
B 2
B 3
C 4
C 5
D 6
I need a macro that can loop, since the number of rows will always be different. I want to delete the repetitive entires in the first column (i.e. the second B and C). Then, I want to format it so that the row for A is white, B is grey, C is white, and D is grey, and so on alternating like that.
Can anybody give me advice on this? It would be greatly appreciated.
Thanks and Best Regards,
Zephix
Configuration: Windows XP Internet Explorer 6.0
Count in excel vba Countif and condition criteria in excel vba Excel 2007 format wont work on excel 2003 Excel date format name of day Excel vba copy highlighted cells from list Excel vba date format Excel vba date formats Excel vba environment variables Excel vba find value,return address Excel vba font color black Excel vba inserting alt-enter Excel vba mouse location spreadsheet coordenates Excel vba open hyperlink folder Excel vba sort rows in a sheet example Gantt chart excel conditional formatting Ms excel vba compare with graph code Vba format multiple sheets at once Vba format time function