vba 2007

Hello, I have a column in Excel with both positive and negative numbers. I would like to receive through VBA a notification on screen every time in the list a number switches sign from one row to the other. The notification is different with a change from positive to negative than from negative...

Hello, I'm writing a VBA program and receive "run-time error 13: type mismatch" In the code below the line in bold receives the error. <code> Let FactornEMA(nEMA) = 2 / (FactorMA(nEMA) + 1) 'run-time error 13: type mismatch Let Cells(1 + nData, colEMA(nEMA)) = FactornEMA(nEMA) *...

I try to make the same calculation on every specifically named sheet of a file. The structure of every sheet is the same, only the length of rows varies. How can I write this in VBA? Thank you.

Hello, I have 2 columns with a variable number of rows in Excel. With VBA I want to perform a calculation on either column A or B. I make that selection through another specific cell where I define a drop-down list with titles of each column to choose from. Through the selection of a column in...

I receive an run-time error message 1004 "autofill method of range class failed" in the following setting, in the 2nd line. In this instance, I want to copy 1 cell from the cell 2 columns before. Range("M3").FormulaR1C1 = "=RC[-2]" Range("M3").AutoFill Destination:=Range("M3")...

Hello, I try to build a table with various formulas in Excel 2007 using VBA. The input data are in 2 different spreadsheets and I will build the table in a 3rd sheet of the same file. In my sample case, I use about 10 rows even though later on that number will increase significantly. I give...

Hi all, I have a macro which contains three nested 'for' loops. Stepping through the code they all appear to work as normal, but when I run the macro the results stop halfway. I have been poring over the code for hours and cannot see why for the life of me. If anyone can spot an error or might...

Running Excel 2007. Hi Guys, I need a macro to delete all rows before the 16/Jan/2012? Date is in Column G and already sorted in desending order. Hope someone can help! Thanks Colin