cell formula

  1. S

    Add Formula With VBA

    I have created a proposal process tracking sheet for my team and have included an "add new client" button. The "add new client" button copies information from a maintenance tab and pastes it at an offset from a cell named "OneAbove" below the last entry on the Proposal Schedule. Sub...
  2. P

    Code to change generate VBA Cell formula

    I am trying to use VBA to automatically take a cell formula and convert it to a string that can be used in VBA to place the formula in a cell. Sorry for my poor explanation. Basically I want to make a simple tool that someone could type in a formula into a cell, use VBA to convert it to a...
  3. C

    Modifying a formula from VBA

    I'm very new to VBA and never really used Excel for calculations. That said, I've managed to get some VBA scripting working in a workbook, with the help of a few people from this forum...
  4. E

    VBA Error In Cell Formula If Statement

    Hello, I'm trying to apply an if statement with VBA to a cell, but it's not having it. Dim iRow, ingredientRow As Integer iRow = 151 ingredientRow = 60 Cells(iRow, 3).Formula = "=IF(C" & ingredientRow & ">0,C" & ingredientRow & ","")" Running this I get an "Application-defined or...
  5. P

    Value of Cell to equal Cell coloured Green when the same row

    Hi Guys, Is there a way of creating a formula to show the value of which ever cell is coloured Green within a the same row I have a Spreadsheet has a column to the right that shows the selected value for each row. This value currently is just a simple =A2 value. A2 is then coloured Green to...
  6. W

    Hyperlink formula with dynamic sheet references

    Hello, I hope someone has experience with my next issue. To put your into my problem I shortly describe the situation I`m having: I have a multisheet xls file, most sheets are named as a company. I have foreseen a macro controlled by a button to go from such a sheet to an analysis sheet. This...
  7. A

    VBA to copy Cell.Formula to cell comment

    Hi everyone, I have had a shot at some code that will check if a cell in the selected range has a formula and if so add this formula as a text string in the same cell's comments. Public Sub CellFormulaToCellComment() Dim CellInRange As Range 'Dim CellComment as String For Each CellInRange...
  8. W

    Cell Reference in Excel Formula

    Hi, I'm wondering if anyone knows how to make a formula to reference a cell based on a solution of another problem. For example, could I do something like this.....? <tbody> A B C D E 1 -2 -3 .11 2 3 -2 .56 3 -1 .18 4 1 .96 5 2 .33 6 3 .85 =if(B6=A2, C6, "") =if(D6=""...
  9. R

    Return Arguments in cell formula as an array

    I am having trouble finding a built in function the will allow me to collect a formula from a cell as an array of its arguments. For example, is a cell has "=sum(A1,G4,L3)", i want an array of 3 with values A1, G4, L3. My goal is to be able to change each argument as i please and return the...
  10. P

    Nesting the large formula inside a cell formula

    Hey, Needed some help with nesting some formula. Suppose I have a row like this: <pre> A B C D E F 1 apple mango orange guava banana 2 2 4 1 5 5 </pre> a) Now, if I want to return the...
  11. R

    Worksheet Change ByVal Formulated Value Change

    Hi there I'm struggling with the following problem and hoping that someone can provide me with some guidance. I'm attempting to use the Worksheet_Change(ByVal Target As Range) to call a macro when Target.Address = "$F$25" however the problem is that F25 is a formulated value. Therefore I'm...
  12. H

    Run Macro on Change of formula result value in cell

    Hello Excellent people! I have made a macro which is designed to change the colour of some shapes depending on the value in a cell. It all works fine when it runs, but it only runs when I exit the formula bar of the cell. Since the taget cell has a formula in it (basic division of two numbers...
  13. J

    Assign Cell Value or Formula From Another Cell

    Hello, I'm using Office 2007 on XP. I am using drop down lists to control the contents of cells. Based on what the user chooses from the drop down menu I would like the cell to either have a value, a formula, or a user entered value put in it. Of course if I put a formula into the cell and...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top