Unhide Hidden Rows

[bruce2444]

I have a worksheet with a macro as follows:

Please Login or Register  to view this content.

What I also need is a code to reverse this or show all rows which have values in column "C".

What's happening is when I change the Value = False and run the macro, the sheet unhides all rows up to the last row which has a value in column "F", then leaves the remaining rows hidden.

Example:

Row 16 has a value, but there are 133 rows in all. I run the code shown, all rows except 16 hide. (Good so far) but if I want to reverse it and show all rows again

Please Login or Register  to view this content.

Everything become unhidden up to Row 16 then the macro stops. Rows 17-133 remain hidden.

[blackworx]

end(xlup).row is returning the last visible row of data, which at the time is 16. there are a few ways around this. if you just want to unhide all rows, then use something like

Please Login or Register  to view this content.

[bruce2444]

Please forgive my lack of knowledge or frustration with this but I understand what you are saying about "end(xlup).row is returning the last visible row of data" so exactly how would I rewrite this code with "Rows(Rows.Count).Hidden = False"

Please Login or Register  to view this content.

The reason I ask is because I have another code connected to a hyperlink:

Please Login or Register  to view this content.

and when I altered my original unhide code, I began getting error in the hyperlink code.

[shg]

I can't tell what you're trying to do (a clear explanation would be better than showing code that doesn't work), but if you want to unhide all rows, then not

Please Login or Register  to view this content.

... which unhides the last row on the sheet, but

Please Login or Register  to view this content.

... which unhides all rows.

If it appears inside a With someSheet block, then

Please Login or Register  to view this content.

[bruce2444]

I have a workbook with numerous worksheets for calculations that many of our employees will be using therefore, trying to simply as much as possible.

What happens is, we receive data from a 3rd party company and this data is copied into the “ACV” worksheet. And at this time we provide our clients with a partial payment. When they purchase the item and provide an invoice, we pay them the remainder up to a predetermined amount.

I would then go to “Payment1” – Click the link to “Generate Worksheet” and enter in the amount the client paid for the item and the worksheet will tell me how much more I have to pay them.

I’m trying to keep the original file as small as possible.

Now sometime the client will only purchase some of the items and provide invoices numerous times thus the reasoning for multiple payment worksheets.

What I’m trying to accomplish with the hide/unhide codes is to hide the rows which haven’t been replaced (because some times there can be 5000+ items). The hide function works fine.

What I’m trying to do now is unhide the entire worksheet after it’s been hidden, in case I missed an invoice or have to refer to a line which was hidden.

The hide code was altered from a “BeforePrint(Cancel As Boolean)” code I had used previously. I just changed a few things so it wouldn't just begin printing once the code ran. The code hides row which have no data in Column F.

I have attached a copy of my worksheet so far, so you can see for yourself in case this explanation made no sense.

[shg]

To unhide rows, replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

[bruce2444]

That works...thanks