I'm having some problems getting this code to work. The code is located in a sheet called "Setup" but I want it to run on a sheet called "New"
I have tried modifying the code to the following
Please Login or Register to view this content.
When I do this it doesn't like the last row of code. Anybody have any ideas.Please Login or Register to view this content.
I needed to change the property from Worksheet to Worksheets.
I got an error on that line when all cells in the range were filled. The IsEmpty always fails and rng never gets Set.
Testing whether rng Is Nothing should fix that.
This also could be done using SpecialCells. The Error code is there to handle the same situation of no blank cells.Please Login or Register to view this content.
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Thanks Mike the first bit of code worked great. My next problem is the "New" sheet contains a formula in the range d9:d44. The code thinks there is data in these fields and thus won't hide the lines. The formula is a simple one (=Setup!B20) but enough to cause it grief. I need to keep the formula. The output in range d9:d44 is not numbers but words. Can we tweak the code so that it looks for a value in the cells.
Thanks
Rob
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks