Macro to hide rows where Column C contains any text or value

Hi guys,

I need some help, I need to create a Macro for work to hide all rows where there is content in Column C. Can you help me?

Regards,
ExcelMikeMcC

Hi,
Welcome to the forum.

You thread title and the description don't complement each other.
Please be specific in the description about what exactly the col. C contains.

Try this.......

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

Thanks for the feedback.

If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

Hi,

Please upload the workbook that contains your macro and the macro given in #5 and in a narrative form describe what the formatting should achieve and what rules drive the formatting.

In practice you probably don't need a macro to format stuff since the standard conditional formatting functionality is often sufficient, but no doubt your formatting explanation will determine this.