Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. hjgoldstein

    Use of Get vs Gets

    Mine was a tongue in cheek comment and a play on words. Sometimes I feel that people take things too literally. I shan't bother you again.
  2. hjgoldstein

    Use of Get vs Gets

    This thread has gotten off track :) Aspiring to mediocrity since 1957
  3. hjgoldstein

    Excel 2007 - Grouped Rows and Hidden Pages. How to exclude from Page Numbering and Printing?

    Let me try it again tomorrow. Thanks again Aspiring to mediocrity since 1957
  4. hjgoldstein

    Excel 2007 - Grouped Rows and Hidden Pages. How to exclude from Page Numbering and Printing?

    Thanks Skip. The only problem with this approach is that the pages have a given number of rows. It is a report that goes to very senior management and the formatting and pagination is very important. I can't just let the system do that so need to move page breaks to suit. Appreciate your...
  5. hjgoldstein

    Excel 2007 - Grouped Rows and Hidden Pages. How to exclude from Page Numbering and Printing?

    Yes I did. The attached is a new file which started behaving in exactly the same way immediately. Aspiring to mediocrity since 1957
  6. hjgoldstein

    Excel 2007 - Grouped Rows and Hidden Pages. How to exclude from Page Numbering and Printing?

    Thanks Andy. I really should read these things before I post :) Here is the file I created. Aspiring to mediocrity since 1957http://files.engineering.com/getfile.aspx?folder=0c95ddbb-45f3-4903-b9d3-45ddf32886a5&file=Excel_Page_Errors.xlsx
  7. hjgoldstein

    Excel 2007 - Grouped Rows and Hidden Pages. How to exclude from Page Numbering and Printing?

    Combo, I tried that too. No joy. Skip, where can I upload a file to? I just created a new workbook with next to no data and the same thing happens. Thanks for your patience Aspiring to mediocrity since 1957
  8. hjgoldstein

    Excel 2007 - Grouped Rows and Hidden Pages. How to exclude from Page Numbering and Printing?

    Skip, In response to your last post. I have 3 pages in Page Break View. I hide the rows for Page 2 Now I see Page 1 and Page 3 in Page Break View and Page 2 displays a blank page in Print preview. Andy, I will try that when time permits. Thanks. Aspiring to mediocrity since 1957
  9. hjgoldstein

    Excel 2007 - Grouped Rows and Hidden Pages. How to exclude from Page Numbering and Printing?

    Sorry, no can do. thanks anyway. Aspiring to mediocrity since 1957
  10. hjgoldstein

    Excel 2007 - Grouped Rows and Hidden Pages. How to exclude from Page Numbering and Printing?

    No macros but plenty of formulae. Sorry I can't upload as it is all highly sensitive data and too much to anonymize. I'll try other stuff. Thanks for the input. Aspiring to mediocrity since 1957
  11. hjgoldstein

    Excel 2007 - Grouped Rows and Hidden Pages. How to exclude from Page Numbering and Printing?

    Yes, I am in page break display mode No, the print area is set to print only the columnd I require. The hidden rows are hidden. Row height is not touched. I tried removing the grouping and hiding the rows and the same happened. There are no hard page breaks. Aspiring to mediocrity since 1957
  12. hjgoldstein

    Excel 2007 - Grouped Rows and Hidden Pages. How to exclude from Page Numbering and Printing?

    OK, bad terminology on my part. I meant that I group rows and hide them. It is the hidden rows that constitute one hidden page - page break at the start and at the end. Previously means that thid didn't happen last time I did it. Nothing has changed as far as I know. No, I am printing one...
  13. hjgoldstein

    Excel 2007 - Grouped Rows and Hidden Pages. How to exclude from Page Numbering and Printing?

    Hi all, I have a problem with page numbering and printing. Long story short... My Worksheet references others and often a page has no data to print. When this happens I group the rows of the affected page and hide them. I don't delete the rows as I may need it in a subsequent version of the...
  14. hjgoldstein

    According to me!

    According to me" seems plain wrong. What I find even more arrogant is "IMHO" which indicates anything but humility. Aspiring to mediocrity since 1957
  15. hjgoldstein

    QA

    Is this the same guy who's glass isn't half-full or half-empty...just the wrong size? Aspiring to mediocrity since 1957
  16. hjgoldstein

    Vanity Plates "XVI"

    Saw this one on a TV mockumentary M12FAT Aspiring to mediocrity since 1957
  17. hjgoldstein

    Half a Movie is better than None

    And of course the comeback Bond Movie Sometimes Mumble Sometimes Again Aspiring to mediocrity since 1957
  18. hjgoldstein

    Half a Movie is better than None

    >>American 1.5707963267948966192313216916398 Shouldn't that be American 1.5707963267948966192313216916398.............e Aspiring to mediocrity since 1957
  19. hjgoldstein

    Half a Movie is better than None

    The Man with one Brain and The thing with one Head Aspiring to mediocrity since 1957
  20. hjgoldstein

    Half a Movie is better than None

    One-and-a-half Coins in the Fountain Aspiring to mediocrity since 1957

Part and Inventory Search

Back
Top