Results 1 to 4 of 4

VBA Formula

Threaded View

  1. 02-24-2009, 05:31 AM #1
    spinkung
    spinkung is offline
    Forum Contributor spinkung's Avatar
    Join Date
    10-27-2006
    Posts
    199

    VBA Formula

    Hi,

    I am trying to write a formula with some variables passed into it. i want to sum up part of a column based on a date range (i've got the range already).


    here's what i've got.....
    ActiveCell.Formula = "=SUM([CourierClaims.xls]TNT!$O" & iloop & ":$O" & ilast2)"
    ...the column is column O and i want iloop & ilast2 to be the variable numbers i pass into the formula. it doesn;t seem to work though.

    Can anyone see where i'm going wrong.

    Thanks.
    Last edited by spinkung; 02-24-2009 at 05:53 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1