Search results

Thank you so much, very very nicely done, -Netbeui

Deb: I read a little deeper into the code and realized all I had to do was paste into the new sheet manually, my apologies. Really quite brilliant, thank you!!

Deb, I ran the code, but nothing seems to happen after execution; what should I look for? am I missing something? I expected it to create a new workseet, and the hidden information to appear there. Thank you for your help, Netbeui

There is a lot of posts involving the exclusion of hidden cells in copying data, but none I have found that targets only hidden cells. Problem statement: I need to copy only the hidden Rows in one worksheet to another new worksheet in the same workbook. Thank you, Netbeui

Can someone please suggest some syntax I could use to get started? Not sure what to do.

OK VBA ninjas, this is beyond my skillset. Problem statement: "Examine a "filename" containing numbers and letters in one cell, and find the most recent revision number in another directly adjacent cell. Hide all rows except row containing the most recent revision." 1) Here's an example of...

Luke M: You are truly an Excel Ninja, thank you so much, it works beautifully! I have not seen anything like it anywhere. And you figured it out so quickly. I have spent a lot of time on this, and was currently studying VB code books, and will be sure to analyze this an learn from you...

Hello, new to this forum! I have searched a lot for answers to this prior to posting the question; please forgive me if I have missed it somewhere. The question: 1)I want to hide rows in a spreadsheet if a cell in that row does not contain specific text. (There may be "other" text in the...