Forum

Hi, Thanks a lot for the explanation on how to use SUMIF But my objective is to replicate exactly the way SUMIF operates with a tailor-made UDF....

Sorry ... my answer should have been clearer ... Sub AddHyperlinks() Dim lastRow As Long Dim myPath As String, fileName As String ' example "OPS...

Hi, Before getting into the macro ... it would seem to me you need to handle the revision string ... =SUBSTITUTE(yourText,RIGHT(yourText,3),"") ...

Hi, Do you need to fill in Blanks in Column A ...??? Sub FilinBlanks() Range("A2:A14").SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=R[-1]...