Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    311

    Unanswered: each named range in ??? Ranges

    I would like to print each named range in my sheet(1),

    i cant find ranges for activesheet, activeworkbook... any help?

  2. #2
    Join Date
    Feb 2004
    Posts
    533
    Quote Originally Posted by mikezcg
    I would like to print each named range in my sheet(1),
    i cant find ranges for activesheet, activeworkbook... any help?
    F3 Pastes a defined name into a formula.
    SHIFT+F3 displays the Insert Function dialog box.
    Actually F3 opens a dialog list of defined range names that may be pasted into the worksheet.

    You can view and manage defined names by selecting the menu item: 'Insert->Name->Define...'
    ~

    Bill

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •