TOM R
Well-known Member
- Joined
- Oct 7, 2006
- Messages
- 731
Hello Members,
I been trying to figure this out for about a week now reading into forums.
I have a work folder that contains about 300 .xls workbooks. Each excel workbook has a different name.
What I like to accomplish is to Open 2 workbooks. That vb would know what is open. If either one the workbooks has matching cells to highlight them vbyellow. cells C11 thru H19.
If any cell is blank do not highlight either them cells. Also, upon closing the workbooks return to original format for them cells. I thought I came cloe but this is over my head.
Any Members that can help with this feat I really could use the help.
Regards, Tom
I been trying to figure this out for about a week now reading into forums.
I have a work folder that contains about 300 .xls workbooks. Each excel workbook has a different name.
What I like to accomplish is to Open 2 workbooks. That vb would know what is open. If either one the workbooks has matching cells to highlight them vbyellow. cells C11 thru H19.
If any cell is blank do not highlight either them cells. Also, upon closing the workbooks return to original format for them cells. I thought I came cloe but this is over my head.
Any Members that can help with this feat I really could use the help.
Regards, Tom