Consulting

Results 1 to 5 of 5

Thread: Adding another cell

  1. #1

    Adding another cell

    I want to add another cell to this formula.
    The formula is '[newest rsi 15 jan.xls]Sheet1'!J160
    I would like to add another cell to the end of the formula like A2
    How do I add the new cell. Thanks
    Max Parris

  2. #2
    VBAX Regular cmefly's Avatar
    Joined
    Jan 2005
    Location
    Toronto, Canada
    Posts
    18
    Location
    Quote Originally Posted by Tenspeed39355
    I want to add another cell to this formula.
    The formula is '[newest rsi 15 jan.xls]Sheet1'!J160
    I would like to add another cell to the end of the formula like A2
    How do I add the new cell. Thanks
    Max Parris
    use the "&" sign...

    [newest rsi 15 jan.xls]Sheet1'!J160&[newest rsi 15 jan.xls]Sheet1'!A2

  3. #3
    Cmefly Thanks for the help, I tried everything I know. You are the man. LOL
    Max

  4. #4
    VBAX Regular cmefly's Avatar
    Joined
    Jan 2005
    Location
    Toronto, Canada
    Posts
    18
    Location
    Quote Originally Posted by Tenspeed39355
    Cmefly Thanks for the help, I tried everything I know. You are the man. LOL
    Max
    glad i can help, max.

    enjoy!

    Marc

  5. #5
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    Hey Max,


    Did you know you can mark your own threads Solved? Go to Thread Tools --> Mark Solved --> Perform Action. Thanks to our own Mark007 for making this possible!!

    Take care!

Posting Permissions

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