worksheetfunction.sum

Hello everyone! First time post here and I am hoping someone will be able to answer a couple of issues I have been having with just starting out with VBA on excel. I have a spreadsheet that will have new info every week so the columns will stay the same, but the number of rows will vary...

Sub notworking() With Worksheets(1) WorksheetFunction.Sum (.Range(.Range("A1"), .Range("A7"))) End With Sub moo() WorksheetFunction.Sum (Worksheets(1).Range(Worksheets(1). _ Range("A1"), Worksheets("sheet2").Range("A7"))) End Sub i dont understand what output iam geeting,i found this code in...

Hello, I have a VBA sub that reads some values off a worksheet, calculates some statistics and prints them into different cells. I built the workbook using Excel 2011 for Mac. At one point I am getting a runtime 11 error: "Division by zero". The line highlighted by the debugger only uses...