Hi
I worte this VBA code, should be easy but nothing is today :-(
I want to hide row 35:38, if cell D34 is text "Nej"
What am I doing wrong ??
/ Kristian
Please Login or Register to view this content.
Hi
I worte this VBA code, should be easy but nothing is today :-(
I want to hide row 35:38, if cell D34 is text "Nej"
What am I doing wrong ??
/ Kristian
Please Login or Register to view this content.
What is Target.Address in your current Sub? This looks like it was once a Worksheet Change Event that was then converted into a regular Sub procedure. Reframe it as a change event and it should work:
Please Login or Register to view this content.
Edit: If you don't want this to be a worksheet change event because you'd rather attach it to a button or something, then you'll just need to define "Target" (I would advise changing the name in this case) as a range and set it as oSheet.Range("D34")
Last edited by CAntosh; 05-10-2017 at 12:37 PM.
If your problem has been solved, please use "Thread Tools" to mark the thread as "Solved".
If you're grateful for this site's existence and would like to contribute to the community, please consider posting something hilarious in our joke thread:
https://www.excelforum.com/the-water...ke-thread.html
Or if you don't want event code:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks