Lawrence Dodge
Member
Hi all--
I am working on a project that I have to open 100+ workbooks with 1-4 spreadsheets per book. Each spreadsheet has hidden rows that I have to open, highlight in yellow(to remember which ones were hidden), edit various cells throughout the spreadsheet, then hide the original rows. Is there an easy way to do. If it is a VBA, please be specific as I am not very VBA savvy. Thanks a lot you are all wonderful
Lawrence
I am working on a project that I have to open 100+ workbooks with 1-4 spreadsheets per book. Each spreadsheet has hidden rows that I have to open, highlight in yellow(to remember which ones were hidden), edit various cells throughout the spreadsheet, then hide the original rows. Is there an easy way to do. If it is a VBA, please be specific as I am not very VBA savvy. Thanks a lot you are all wonderful
Lawrence