3 Parts - Conditional Hide Row, Remove Case sensitivity, Dynamic Range

[mthart]

i currently have a spreadsheet and would like to be able to conditionally hide rows that are "completed".

I have set up the basic code and 2 buttons that can hide and show the rows.

With my code, you MUST WRITE "Completed" exactly and id like to be able to have some variation in the case of it. like all lowercase.

And my current range is set at "a = 2 to 174". Id like it to be dynamic so as I add more rows it will auto-update.

Below are samples of the codes I have written.
---------------------------------------------------------------
to hide rows

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

module to create dynamic range
i cant refrence it in the above code

******************************

need something to remove case sensivity

[JLGWhiz]

This for your hidden rows.

Please Login or Register  to view this content.

A dynamic range can be created in more than one way. In some cases, a named range can be dynamic. You can also just reference the UsedRange and Excel knows which rows and columns are being used. You can limit the dynamic range to one column by using the End(xlUp) function, eg.

Please Login or Register  to view this content.

Or you can use several columns by

Please Login or Register  to view this content.

BTW, you should use code tags when posting code. To do that, select the portion of your post that is code, then click the pound symbol (#) in the tool bar of the reply box. You should edit your original post and fix it or the moderator might scold you.