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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba for hiding rows
Dim i As Long
i = 1 Do i = i + 1 Loop Until Range("A" & i).Value < "" Rows("2:" & i - 1).Hidden = True -- HTH RP (remove nothere from the email address if mailing direct) "goofy11" wrote in message ... 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. |
Reply |
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 |