morning all....
is there any macro function for hiding columns ? tried recording my macro and putting it into my existing workbook, but can't seem to get it to work..
the bolded sentence states that in between those to 'searches', i need to hide 3 columns....any solutions ?
Please Login or Register to view this content.
thanks in advances
mfg
eddy
Last edited by EddyAddelan; 11-14-2006 at 05:55 AM.
Sheets("TAB_HVT_STANDORTE_SHELF_BB").Activate
Search ("ONKZ")
'3 columns are suppose to be hidden here
Search ("HVT_NR")
Search ("NE_KENNUNG")
Sheets("BREITBAND").Activate
Hi,
Is there a criteria to what gets hidden, or do they just get hidden?
hye dave...
they just need to be hidden...i know it sounds easy, but the thing is, i have this search function already in my workbook, and it pastes all the searched columns beside each other...i just wanna add 3 new columns in between those searched columns and get it hidden(in order to have the head listing similar with my other sheet)
hope u get me on this one
cheers
eddy
not sure what you exactly mean but you can incorporate the following command based on your need:
columns(n).hidden = true
this will hide the nth column
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks