Hello,
I am using the below macro to hide an entire column:
I would like to do the same with a range:HTML Code:
E.g: hide unhide the range E43:K47 (using name manager the range = SCHEDULE2)
--> I have tried to replace Columns by range but it doesn't work
Thanks,
Graig
To my knowledge you can't hide part of a row or column without hiding the rest of it.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
If It is not possible, Let's say that I have named the rows "SCHEDULE". Can you please help me to adapt the above macro to hide the rows?
Thanks
Please Login or Register to view this content.
Or:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks