Results 1 to 3 of 3

Using excel functions in VBA program

Threaded View

  1. #1
    Registered User
    Join Date
    02-03-2008
    Posts
    12

    Using excel functions in VBA program

    I am hoping someone can help. I need to use an excel function in a VBA program, but within the function I need it to divide 2 cells. This is done in a for next loop and I need it to do the division down a column. I have been able to use the function in one cell but I can't figure out to have it move down the column.
    The line I have is:

    Worksheets("Sheet1").Cells(a, 10).Formula = "=exp(-h2/i2)"
    I need the -h2/i2 to change to h3/i3 when the loop goes to the next cell and so on.

    I hope someone can help or give me an idea of where to go next for the information.

    Thanks in advance.
    Last edited by VBA Noob; 02-03-2008 at 07:23 PM.

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