references

  1. bmckenna

    How to remove/change "invalid references" warning???

    I was wondering if its possible to remove or change the "A formula in this worksheet contains one or more invalid references. Verify that...etc..." warning box?
  2. G

    Enter SUM formula using VBA

    Dear All, I am trying to put a formula into a cell using VBA but am having trouble with the range of cells. I am using Excel 2003. I have a column of amounts with some blanks mixed in. I know my first cell in the range is always row 2 of the column of the current active cell. I know the...
  3. L

    Macro - Checkbox to hide certain column (not always in the same location)

    I have a userform that I created which has a lot of checkboxes on it. Each checkbox corresponds to a column of data in my sheet. As of now, when I check the box, the column of data is made visible. So I can select which columns of data I want to see. My question is how can I make the...
  4. E

    Macro to copy formula while keeping original cell references

    Hi, I'm trying to create a VBA macro that will allow me to copy a formula from one sheet to another whilst keeping all the original references. E.g. If the formula on Sheet1 is: = sum(A1:B6) then the copied formula on Sheet2 would read =sum(Sheet1!A1:Sheet1!B6) You can do this by...
  5. L

    Automatic Changing of References in Formulas

    Ok, so I set up a long column of cells in a worksheet to reference another column in a different sheet. But, the references are off by one. For example, the first few in column are: =Schools!B4 =Schools!B12 =Schools!B8 and I want them to change to: =Schools!B3 =Schools!B11 =Schools!B7 How...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top