Reply to thread

Message: [QUOTE="E.Sortland, post: 6217617"] This selects all everything in the workbook. I have some text boxes outside the selected range that gets included, even though they have been set as do not print in their properties using your suggestion... ? Some more background. I have "static" information in A1-H7 and A8-A315 This has been entered into print setup "titles" (norwegian excel so I do not know the exact wording in english) So i want to select printarea from B8 - Bx to H8 - Hx. x can be anything from 8 to 322. Setting this manually works without problems. Also: the area D8-H322 contains forumlas used to look up SKU numbers in B8-322, so they contain "information" even when displaying "". Just need to know the "code" for a the current "selection-range". Best regards, E.Sortland [/QUOTE]