Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Hide Colums
Hi There fellow community member
Please Help I HAVE A SPREADSHEET WITH ROW AND COLUMN HEADERS WHICH IS UPDATED EVERY MONTH. i NEED TO CREATE A MACRO THAT WILL HIDE AND UNHIDE COLUMNS TO ENABLE ME TO VIEW 6 AND 12 MONTHS DATA ALTERNATIVELY. What I need for the macro to do is the following 1) Go to row 6 (where my data starts) 2)from row 6 search and identify by column the last column that contains data(as every month i add a new column. 3)Offset the last column(iLastCol) by 6 4)Hide columns from column b to iLastCol-6 (Column A contains the Row headers) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide data in specific rows/colums/cells in Excel 2003 | Excel Discussion (Misc queries) | |||
Chart disappears if you hide rows/colums with data. | Excel Discussion (Misc queries) | |||
What is the quickest way to hide a lot of rows and colums ? | Excel Discussion (Misc queries) | |||
How can I hide data in colums. | Excel Discussion (Misc queries) | |||
Hide colums based on dropdown list | Excel Programming |