1. D

    vba to insert copied row below row of a specific value

    I'm new to VBA but trying to learn and wrap my head around the way vba works. What I need can be seen below: <tbody> Formula1 Formula2 Formula3 Formula4 1234 Step1 Step2 Step3 DOG Complete Formula1 Formula2 Formula3 Formula4 5678 Step1 Step2 DOG Formula1 Formula2 Formula3 Formula4 4321...
  2. M

    rogue row in pivot table - "Formula1"

    I've inserted a pivot table and in the row labels column one of the labels is 'Formula1'. I don't have any rows labelled formula1 - where the heck is this coming from!
  3. E

    Conditional Formatting with VBA and xlExpression Formula1: with VBA Variables and Text

    Hello Mr. Excel! I want to start by saying a quick thank you! I love this site. I have tried to find answers in previous posts but I haven't found anything to find material that applies directly here, yet. I've been using VBA to new worksheets that compile information from a "Source"...
  4. D

    Iterating through Conditional Format Formulas not working as expected

    I read Bill's "VBA and Macros in Excel 2007" chapter on Conditional Formatting. That said, I'm finding that iterating through the ConditionalFormats.Formula1 collection to not work as expected. For example, a cell shows in the User Interface the following three rules: Rule 1...
  5. R

    VBA Conditional Formatting Formula Simple Error

    I am having problems with my code snippet below. I am almost certain that the error lies in Formula1:=CStr(ucl.Address). I can get the code to work by changing it to ucl.Value, but I need the formatting to be linked to the ucl CELL, not it's value, so that it will update when the value in...
  6. S

    FormatConditions.Add for xlExpression & formula - fails!

    I can't seem to get this conditional formatting code to work. Error:Run-time error '5' Invalid procedure call or argument xlCellValue works: With .Range("tblGlobalData[Response Time]").FormatConditions _ .Add(xlCellValue, xlEqual, "FAIL") .Font.ColorIndex = 3...
  7. L

    FormatConditions Formula1 differences between 2003 and 2007

    Step1: Select range 'A1:B5' Step2: Fill with numbers Step3: Apply this FormatCondition: Formula '=A1=2', with Red Font. Then, all cells with contains number 2 are Red. Step4: Select cell 'B2' In VBA, Excel 2003: Msgbox ActiveCell.FormatConditions(1).Formula1 shows: '=B2=2' In VBA, Excel...

Some videos you may like

This Week's Hot Topics