Consulting

Results 1 to 2 of 2

Thread: Refer to cells instead of hardcoding text and numbers

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Jul 2019
    Posts
    36
    Location

    Refer to cells instead of hardcoding text and numbers

    21,26,27,32,33 , ""AC"",""BR"",""DX"",""GE"" instead of hardcoding like this, how can I refer to cell references- need to create a separate Sheet where I can add these so the user can add/remove as they wish.
    There are multiple forumulas.

    I have this in VBA code:
     ActiveCell.FormulaR1C1 = "=SUM(SUMIF('15-Aug-19'!C[-5], {21,26,27,32,33,""AC"",""BR"",""DX"",""GE""}, '13-Aug-19'!C[-3] ))"

  2. #2
    VBAX Regular
    Joined
    Jul 2019
    Posts
    36
    Location
    any ideas anyone

Tags for this Thread

Posting Permissions

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