add formula

Hello, I'm new to VBA scripting, and have tried a few versions posted here, but none seem to work for my layout. I'm trying to make a sorted grocery list that calculates the lowest price. I've sorted out all the formulas to get the information, what I can't do is add lines, so the list is cut...

HI am new to VBA and trying to create a Marco to add columns to E and L, which i have a as Range("E1").EntireColumn.Insert Range("L1").EntireColumn.Insert but then i want to add a formula to E and L of =Left(D5,5) and =left(k5,5) going down to the last row. but if in row 6 it will be D6 and...

Hi all, Obligatory "new to VBA"... I'm trying to create a macro for my boss that would allow him to 1) Add a column to the far right of a table in any workbook 2) Name that column "Day of the week" 3) Find a column in the table with the header "Adj Order Date" and apply a formula in the...

I have this Formula but when i try to add it into a cell it says Application-defined or object-defined error This is the formula ProgForm = "=IFERROR(INDEX('" & PathFile & Filename ProgForm = ProgForm & "'!Division_6[Programmer],AGGREGATE(15,6,(ROW(" & PathFile & Filename ProgForm = ProgForm &...

Hello again, I was helped with a macro that splits a 'Master' sheet into other named sheets based on categories in column "A" of the 'Master', and copies the column titles and format to the new sheets and each sheet's related data....That part works perfectly. ISSUE: My problem is that the...

I am trying to get user input from an input box and add that value to an existing formula. So far, I have been able to get the user input to work but am not sure how to add it to the formula. Dim strnewassembly As String strnewassembly = InputBox("Please enter the Assembly Number you would...