Visit my channel to learn MS Word, Excel, and AutoCAD.
Click Following links to watch other videos:
• Object snap, Object sn...
Copy Paste This code in VBA
Function SumFeet(x As Range)
Dim y As Range, z As Double, m As Double
m = 0
For Each y In x
z = WorksheetFunction.DollarDe(y.Value, 12)
m = z + m
Next y
SumFeet = WorksheetFunction.DollarFr(m, 12)
End Function
Link of Practice File
www.dropbox.co...
6 сен 2024