Results 1 to 2 of 2

Thread: Excel VB Formula

  1. Apr 5th, 2002, 02:01 PM #1
    texas
    texas is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Aug 2001
    Location
    Austin
    Posts
    397

    Excel VB Formula

    this is what I'm trying to do.

    startD = 5
    endD = 1

    DateD = startD - endD

    ActiveCell.FormulaR1C1 = "=SUM(RC[XXXXXX]:RC[-1])"


    How do I get "DateD" in place of the "XXXXX" and have it work?
    Reply With Quote Reply With Quote
  2. Apr 5th, 2002, 02:50 PM #2
    texas
    texas is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Aug 2001
    Location
    Austin
    Posts
    397
    got it


    DateD = (startD - endD) + 1

    ActiveCell.FormulaR1C1 = "=SUM(RC[-" & DateD & "]:RC[-1])"
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules


Click Here to Expand Forum to Full Width