Previous Topic Next Topic

Excel VBA Help: Formatting Tables

Closed
Zephix - Nov 3, 2009 at 02:46 AM
 johnny - Dec 27, 2009 at 11:08 PM
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

1 reply

Answer 1 / 1
Zephix
Nov 4, 2009 at 01:14 AM
Right now, I have managed to get the table to look like this:

A 1
B 2
3
C 4
5
D 6

I still need help on the formatting though. So row 1/4 in one color , row 2/3/6 in another color.

Thanks
0
Zephix
Nov 11, 2009 at 02:57 AM
You are all useless. I found out how to do it on my own using an IF and a lot of other stuff. I will not paste my code because I did not receive any of your help and it seems as if nobody else needs it either.
0
johnny > Zephix
Dec 27, 2009 at 11:08 PM
You're a dork.
0