• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

mark hidden rows

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
 
They are bill of ladings and we hide the items that don't get shipped often but enough that we don't want to always type in the data. Also as I am editing the cells I have to reorganize most of the rows. Thanks for any help.


HAPPY NEW YEAR - I hope you obtain the goals you set for your personal success.
 
Back
Top