I wrote a sub in VBA that displays a set of colors. Now I want the set of colors to output in reverse. Red, Green, Blue, Purple, Yellow output would change to Yellow, Purple, Blue, Green, Red. Been trying to figure it out all morning, but can't seem to get it.
This is the color output I am trying to show in reverse.
Please Login or Register to view this content.
Maybe ....
Please Login or Register to view this content.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Tried that already, and still gives me the same color output as the original.
Last edited by Paul; 10-26-2010 at 05:29 PM. Reason: Removed quote of full previous post
Hello xlsnovice,
You need to keep the column counter separate from the color index counter. Here are two macros to demonstrate the point.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Please Login or Register to view this content.
In fact, you don't need to change to this:
Please Login or Register to view this content.
It just changes the order the cells are filled
Thank you, works perfect!Originally Posted by Leith Ross
Last edited by Paul; 10-26-2010 at 05:30 PM. Reason: Removed quote of full post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks