V3 is a good reflection of my current workbook.
PTO Accrual
-
-
-
Great ...
So will start from this base to remove all merged cells ...
Should you want to have your Italics macro included in the Version 4 ... please post it with your next message ...
-
Attached is your Version 4 ... without merged cells ...
For your visual alignment, have used Center Across Selection ...
Hope this will help
-
Here is the macro.
Function SumItalics(rSumRange As Range)
Dim rCell As Range
Dim vResult
For Each rCell In rSumRange
If rCell.Font.Italic Then
vResult = WorksheetFunction.Sum(rCell) + vResult
End If
Next rCell
SumItalics = vResult
End Function
-
Thanks for the macro
How do you need to use this UDF ...?
Thanks for describing how you want to apply it ...
-
-
Hello,
Have you had a chance to take a look at Version 4 ...?
Is it in line with your expectations ...?
-
Hi again,
Attached is your Version 5 ... with some cleaning ... no merged cell ...
Main suggestion is to move Data on its own tab and keep them separate from your Recap of your 17 Hires ...
Hope this will help
-
Thanks for your Like
-
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!