Macro for Hide Or Unhide Rows based on Cell Text

[Neilesh Kumar]

Hello Experts,

I do have worksheet where a tab name P&L (CY Plan) and in column B from Cell 2 to Cell 269 where i am looking for the Macro for Hide and Unhide the rows based on Cell text if it includes "Blank" then the particular rows should be hidden and if the "Blank Text does not include then it should be appear.

Request to you please do help me out Dear Experts.

Thank you for your precious phase and valuable support.

Regards,

Neilesh

[AliGW]

How does this differ from this thread?

https://www.excelforum.com/excel-gen...ith-cells.html

[Neilesh Kumar]

How does this differ from this thread?

https://www.excelforum.com/excel-gen...ith-cells.html

Dear Expert,

That required macro was with formula and if error and here i am looking for if the with formula where the result is "Blank" and i did tried but it is not working from my end. Request to you please help me out on the same.

Thank you for your valuable support.

Regards,

Neilesh

[AliGW]

OK - fine. You can continue in this new thread, then. However, I will move it to the correct section of the forum.

[Neilesh Kumar]

Dear Experts,

Request to you please do help me out on my thread.

Regards,

Neilesh

[AliGW]

Please be patient. Remember, those helping here do so voluntarily - this is not a paid 'service'. Those who help are living all over the globe.

[alansidman]

Please supply a sample worksheet.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Neilesh Kumar]

Please supply a sample worksheet.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Dear Experts,

Please find here attached sample workbook where i am looking for the macro for the First Tab "P&L (CY Plan)". Request to you please do help me out.

Thank you for your precious phase and valuable support.

Regards,

Neilesh

[Neilesh Kumar]

Dear Experts,

Request to you please do help me out on my thread.

Regards,

Neilesh

[Richard Buttrey]

Dear Experts,

Request to you please do help me out on my thread.

Regards,

Neilesh

@Neilesh

Ali asked you only a couple of hours before your post to be patient and told you why.
None of like being exhorted to step in and come up with a solution on demand. There are after all hundreds of others who are seeking help at the same time and constant chivvying will be counterproductive.

If you need an instant service then put the request in the Commercial Services area with a note that you expect a result within say an hour - and be prepared to offer a premium for such a service.

[alansidman]

This worked for me in your example

Please Login or Register  to view this content.

[Neilesh Kumar]

This worked for me in your example

Please Login or Register  to view this content.

Dear Expert,

Thank you so much for your precious support. Thanks a ton Sir.

Regards,

Neilesh

[Neilesh Kumar]

This worked for me in your example

Please Login or Register  to view this content.

Dear Experts,

The provided code is not working in case of worksheet is protected with password and it is only works when the worksheet is unprotected. So may i expect the new macro code for the same in case of worksheet is protected with password.

Thank you for your precious help and valuable support.

Regards,

Neilesh

[Neilesh Kumar]

Dear Experts,

Request to you, Please help me out on my raised thread. Thank you for your precious phase and valuable support.

Regards,

Neilesh

[alansidman]

Amend the code using this tutorial

https://analysistabs.com/excel-vba/p...tect-workbook/

[guru008]

Sub hhide()

Dim rCell As Range
Dim rRng As Range

x = 1
Set rRng = Sheet1.Range("C1:C600")

For Each rCell In rRng.Cells
x = x + 1
If rCell.Value = "" Then
rCell.EntireRow.Hidden = True


End If

Next rCell

End Sub

[Neilesh Kumar]

Dear Expert,

I have gone through the article but the solution i could not find for my requirements. Request to you please do provide the macro here as per the requirement. Thank you for your precious help and valuable contribution.

Regards,

Neilesh

[alansidman]

Insert this at the beginning of your current code. Insert your password in the appropriate section of the code

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

[Neilesh Kumar]

Insert this at the beginning of your current code. Insert your password in the appropriate section of the code

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

Dear Expert,

The provided code throwing an error with message box "Compile error - Invalid outside procedure". Request to you kindly do provide the required code.

Thank you for your precious phase and valuable support.

Regards,

Neilesh

[Neilesh Kumar]

Dear Experts,

Request to you, Kindly do provide the required codes.

Regards,

Neilesh

[Richard Buttrey]

The error message is telling you that the code you've added is not inside a procedure. i.e. not between a Sub() and End Sub block of code.
I suspect you've added it above a Procedure.