Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba for hiding rows
I'd like to create a macro that will hide rows between to points. The
spreadsheets I'm working with are always set up the same. The title of the spreadsheet is in cell A1. Then column A is blank for a varying number of rows (depending on the spreadsheet), until it reaches the column header row with the actual data range. There is miscellaneous information in column B. I want to be able to hide all the rows between the Title row (always row 1) and the column header row (row location varies). The typical setup would look like this: Column A Column B Column C Sales History Report miscellaneous miscellaneous miscellaneous miscellaneous Item Sales Units xxxxx $1,000 500 Can someone help me with this code? Thanks, Jeff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Color alternate rows when after hiding selected rows | Excel Worksheet Functions | |||
Hiding Specific Rows Based on Values in Other Rows | Excel Worksheet Functions | |||
Hiding a button when hiding rows | Excel Discussion (Misc queries) | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Copying Rows when hiding other rows | Excel Worksheet Functions |