LinkBack URL
About LinkBacks
Hi,
I need a simple macro that will automatically do the following:
If cell AF44 = 0, hide rows 45 through 94.
If cell AF44 = 1 or greater, unhide rows 45 through 94.
Please tell me specifically where to put the macro. I'm very new to macros.
Thanks
Hi,
I need a simple macro that will automatically do the following:
If cell AF44 = 0, hide rows 45 through 94.
If cell AF44 = 1 or greater, unhide rows 45 through 94.
Please tell me specifically where to put the macro. I'm very new to macros.
Thanks
Hi Russ,
Put this in the Worksheet module:
Directions for running the routine(s) just supplied
Please Login or Register to view this content.
Copy the code to the clipboard
Press ALT + F11 to open the Visual Basic Editor.
Open a macro-enabled Workbook or save your Workbook As Macro-Enabled
Click on the appropriate sheet
Type "Option Explicit" then paste the code under it
And, you should be ready to go
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
See the attached file.
if you push the button the code will run.
If AF44 input is 0, and push the button, the rows will hide.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
And this one will do it automatic
See the attached file.
Please Login or Register to view this content.
xladept and oeklere...thanks for the formula, It works great in a new worksheet, but not in the worksheet I'm using, Could it be because AF44 has a formula in it? =SUM(A44:P44)
Thanks
Maybe:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks