Conditionally hide rows in Excel

[dvlchd3]

Hello. I am working on a workbook where I would like to conditionally hide rows. I know this needs to be done with VBA, however, I have never used VB period. I have rather fluent in C++, Java, PHP, Perl, etc, however, I have never messed with VB or VBA.

Basically I want to make a conditional statement like

Please Login or Register  to view this content.

Does someone know of a VBA script that will accomplish this? I appreciate any help you can give me.

[Jokacave]

Hi dvlchd3,

Try something like

Please Login or Register  to view this content.

[dvlchd3]

Remember, I have no idea what I'm doing in VBA. I have done a few quick tutorials, however, I really still have no idea how to use it.

Here is what I want to do. I have created a template that dependently shows or hides content based on the date that is inputed in the first worksheet. Every other sheet in the workbook is dependent on this date. After the template is turned into an excel file, I want the macro to go through EVERY worksheet, and check to see if any Rows in the A column have blank data, if they do, I need to hide that row. The catch is, the range to search through varies from worksheet to worksheet.

Is this even possible?

[dvlchd3]

Remember, I have no idea what I'm doing in VBA. I have done a few quick tutorials, however, I really still have no idea how to use it.

Here is what I want to do. I have created a template that dependently shows or hides content based on the date that is inputed in the first worksheet. Every other sheet in the workbook is dependent on this date. After the template is turned into an excel file, I want the macro to go through EVERY worksheet, and check to see if any Rows in the A column have blank data, if they do, I need to hide that row. The catch is, the range to search through varies from worksheet to worksheet.

Is this even possible?

Does anyone have a possible solution?

[Jokacave]

Hi dvlchd3,

Check the attached file and see if it is what you want...
My english is poor and sometimes I don.t understand what people want

[dvlchd3]

This is not really what I want. Let me just start over my explanation, because I believe it has changed slightly since I started this thread. I have become alittle more familiar with VBA, so you don't have to treat me like a baby first learning the language, lol.

Anyway, I have written a macro (below) to run when the template file is opened. After the information is entered, and the workbook has updated based on the entries from the user. I need to search the ENTIRE workbook (all 26 sheets) for any cells in the A column that contain the word "hide" [without the quotes], and hide that row.

Here is what I have started as the macro to do this task. I will explain the problem after the code:

Please Login or Register  to view this content.

The problem I am encountering, is it seems to sit and do ALOT of stuff after the information has been entered. The screen flickers for a good 1-2 minutes, however, it only hides the rows that are on sheet 1.

I also assume there is a much easier way to search everysheet in a workbook besides selecting each worksheet individually. This makes the code extremely long. Does anyone have a solution!?!?

I'm really starting to get frusturated, and think Microsoft needs to switch to a much newer, more widely used lanuage like C or C++, or something, just not Basic which has been around for how long?? and is how inefficient as compared to a lanuage like C?!?!? I apologize for the wild tangent I just went through, however, this is the pain I feel when trying to push my way through this annoying lanugage that is a form of a lanuage that has been around since 1964!

Thanks for any help anyone can give me! I really appreciate the community here, and there seems to be a lot of people that have a lot of experience with this stuff, and they don't mind taking the time out of their busy schedules to help us newbies...Thank you!

DAN

[Jokacave]

Hi dvlchd3,

Check the attached file and see if we are near of what you want...

[dvlchd3]

Hi dvlchd3,

Check the attached file and see if we are near of what you want...

Yes, thank you very much for your help!