Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi,

    I am currently using the following formula:

    Range("A3").FormulaR1C1 = "=nat!R[-1]C"

    The formula is in Sheet2 (Stats) looking at Sheet1 (currently (nat)).

    I need this to work without knowing the sheet name, only refering to the fact that it will always be sheet 1.

    I did:

    Set w1 = Sheets(1) - but can that be used in the formula? Thanks

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Are you looking for:
    Range("A3").FormulaR1C1 = "='" & worksheets(1).name &"'!R[-1]C"

    This is the first worksheet listed in the workbook...

  3. #3

Posting Permissions

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