Reply to thread

Message: [QUOTE="MitchellWMA, post: 1237435"] Dave, hi! Thanks. I guess this is one of those things that in trying to be helpful, Excel has gone "backwards" since it is something that XL2K does automatically. No spreadsheet that I've converted to 2003 or made in 2003 has this option in the autofilter, which is the feature that I put on top of the columns to filter the rows by. I don't name these ranges, not here, because the rows keep getting bigger and bigger as information is added, so the problem may lie in the fact the XL2003 requires me to do an extra step XL2K never did, so it will be good to know. The rows are, indeed, blank. They don't even, in this case, have formulas in them. They are conditionally formatted, yes, for row colouring purposes, but that's it. It's a common feature that I have used for several years now where the print button is attached to a macro that filters out blank rows, sorts and then brings up the print dialogue box. In 2003, this never works now, if memory serves. Is there a link to something that will help teach me to do the same in 2003 as in XL2K, by any chance? It's a feature I'm sorely missing. The workaround I'm using is to select the rows in question and print the selection. Hopefully there is something that can help bring the earlier, better functionality back. Thanks! :oD [/QUOTE]