Question

Locked

VBA RemAlpha Function: End of Statement

By roundtheworld1122 ·
Dear all,

Please help!

I have cells that contain both a number and letters at the end (0.00 BDL). I want to eliminate all the BDL by a function in VBA. But this function is not recognized in Excel 2007. What is wrong with this? Thanks.


Function RemAlpha(strS As String),RemAlpha = Val(strS)

End Function

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Back to Software Forum
2 total posts (Page 1 of 1)  

Software Forums