LinkBack URL
About LinkBacks
Hello everybody! How can I save to a txt file in C:\date.txt, only the cells colored with color 6 (vbyellow) in excel?
Hello everybody! How can I save to a txt file in C:\date.txt, only the cells colored with color 6 (vbyellow) in excel?
... should do it, though I daresay you may wish to refibe the spec.
Please Login or Register to view this content.
Sorry i expressed myself badly. I have a spreadsheet where column D, possesses different numerical values, where some are colored in yellow and others are colorless. I need a procedure to copy the colored cell (color index = 6). elsewhere and save the values of colored cells in a txt file in c: \ code.txt.. can you help me ?
Last edited by brazuk; 11-06-2012 at 01:47 PM.
Personally, what I want is relatively simple for those who know about excel / vba.
Rather I need an auto-filter that filters the column "D", leaving only the cells with interior color = 6 (yellow), more or less like this:
But I can not. What could be wrong?Please Login or Register to view this content.
U can use this code to hide all non-yellow in column D
Please Login or Register to view this content.
Boon
Thanks bheanloh, it not was exactly what I wanted but thanks to your code i got to what I wanted, thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks