vba formula inputs

  1. A

    Variable Column Products using Macros

    Hello, I have a variable number of columns. Column N is where I need the product of Columns L and M. I also have a variable number of rows for Column N to fill. I have no idea how to even begin to write this. I have this so far but it doesn't even begin to work. Dim lngLstCol2 As Long...
  2. T

    VBA Formula to have excel send out an email message once a certain cell reaches below a certain quantity

    Hi, Just looking for some help as I have limited knowledge when it comes to VBA. What I'm trying to do is have an email send out to two individuals once a certain cell reaches below a certain number. The excel spread sheet tracks our stock quantities of a particular item and we want to be...
  3. H

    Error when entering formula using VBA

    I have a formula that I'm using which works and gives me the right value. =COUNTIF(bommech[PO1 No],"")+COUNTIF(bomelec[Procurement Status],G4) However when I try and enter the exact same formula through VBA using, I get "Run-time error 1004: Application defined or object defined error". I...
  4. Z

    Name cell and use in formula (VBA Excel 2007)

    Hello, I'm trying to figure out the following: I have a cell in Excel sheet that I define with a name. Next I want to use that specific cell in a VBA calculation, using that name. How can I write this code in VBA? as an example: calculate an average of a group of cells, then multiply that...
  5. L

    vba Formula Problem

    Hi, I'm wanting to input a formula (and not a value) into the activecell, which adds the first cell to the left and right of the activecell e.g. if my activecell was B1 the formula would be "=A1+C1" What I'm wondering is, is it possible to generalise the above, that is, if my activecell was E1...

Some videos you may like

This Week's Hot Topics