Spreadsheet Q&A

Recent Answers

2009-11-21 Excel - Using INDEX with multiple criteria:

Norm, This isn't my site. This belongs to Allexperts. I am just one of the volunteers here. Anyway, Bob Phillips has a detailed explanation of using sumproduct in this way - much more detailed

2009-11-21 Excel - #DIV/0! error:

Angela, my formula produces a zero stored as a number. how it looks depends on how you format the cell with the formula. You said you formatted it as currency so the $ signs line up. Nothing in my

2009-11-21 Excel - Open workbook without defining the path:

steven, first, you asked for code to open a file without the path. But I don't know where that code will be run from. So I don't know what the relationship is between the workbook that is running

2009-11-21 Excel - delete row where cell has specified text:

Sub DeleteNotDue() 'untested Dim Rg as Range On error resume next For i=Activesheet.Usedrange.rows.count to 1 Step -1 Set Rg = Nothing Set Rg = rows(i).Find("not due",lookin:=xlFormulas) If

2009-11-20 Excel - VBA search using inputbox:

Andreas, Sub FindMultiple() Dim tgt As Variant, sh As Worksheet Dim r As Range, sAddr As String Dim rw As Long tgt = InputBox("Enter String to search for") Set sh = Worksheets("Sheet2") With Worksheets("Sheet1")