+ Reply to Thread
Results 1 to 3 of 3

Problem with a relative reference in a formula.

  1. #1
    Registered User
    Join Date
    05-09-2012
    Location
    tampa
    MS-Off Ver
    Excel for Mac 2011
    Posts
    5

    Problem with a relative reference in a formula.

    Hi I am creating a conditional formatting script for my work sheet and I have it working but I need to set the formula in the script to a relative reference so it can be used in other places in the spreadsheet. When the script reaches the point where the line below is executed I have a region selected and I want to have the cell that the conditional formatting depends on to be three row down and 16 columns to the right. What I have below is giving me a type mismatch error. Novice here so please give me details The cell where the formula should be is $Q$110<0 THANKS!


    Please Login or Register  to view this content.

  2. #2
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2007/2010/2013
    Posts
    1,416

    Re: Problem with a relative reference in a formula.

    have you tried adding the .address into that, looks like that should work. Also, you need to use & to join strings (not plus signs)/


    TRY:
    Please Login or Register  to view this content.
    That would be my first debug step.
    Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.

  3. #3
    Registered User
    Join Date
    05-09-2012
    Location
    tampa
    MS-Off Ver
    Excel for Mac 2011
    Posts
    5

    Re: Problem with a relative reference in a formula.

    Quote Originally Posted by GeneralDisarray View Post
    have you tried adding the .address into that, looks like that should work. Also, you need to use & to join strings (not plus signs)/


    TRY:
    Please Login or Register  to view this content.
    That would be my first debug step.
    That worked!!! Thanks for the school'n. Below is the finished script.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1