Hi
I am putting together my school timetable and it would be really useful if I could highlight two identically sized ranges and run a macro that would swap the contents and the background colours. I have found a macro online that will swap the contents, but not the colours.
I have attached a sample of the timetable to illustrate my issue.
Many thanks for your consideration.
Desisample.xlsx
Try this to "copy" the formats
Please Login or Register to view this content.
If this was helpful then please click the small star icon at the bottom left of my post. A little appreciation goes a long way.
Thank you for your reply.
How would that fit into this code which swaps the content?
Desi
Please Login or Register to view this content.
Last edited by vlady; 01-15-2013 at 07:35 PM. Reason: dont forget code tags around codes
desimck
A simple if not technically elegant solution that should meet your needs
swapsample.xlsm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks