I would like to make the below code more flexible. Can someone show me a way that I can have the user input the column in a simple input box?
So instead of having to go into the VB editor a novice could change the reference easily...
Code:Sub FormatTextAsNumbers() Range("Q:Q").Select 'specify the range which suits your purpose With Selection Selection.NumberFormat = "General" .Value = .Value Columns("Q:Q").Select 'Changes Selection to two decimal format Selection.NumberFormat = "0.00" End With End Sub




Reply With Quote
Bookmarks