I want to hide rows and columns based on cell J5, if j5=5 then hide rows 14-18 from columnc-L,.
I am new to VBA and aprecaite your help
I want to hide rows and columns based on cell J5, if j5=5 then hide rows 14-18 from columnc-L,.
I am new to VBA and aprecaite your help
Try:
![]()
Please Login or Register to view this content.
What I meant is if J5= i, then show rows from 14 to 14+i and hide the rest.
i=1,10
regards
Does this work?
![]()
Please Login or Register to view this content.
Last edited by Mumps1; 11-23-2012 at 03:41 PM.
Thanks a lot, done
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks