Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- '**************************************************************
- ' Select a Range with your mouse then bolds them
- ' NOTE: Can change from bold to something else
- '***********************************************************
- Sub RangeDataType()
- Dim rRange As Range
- On Error Resume Next
- Application.DisplayAlerts = False
- Set rRange = Application.InputBox(Prompt:= _
- "Please select a range with your Mouse to be bolded.", _
- Title:="SPECIFY RANGE", Type:=8)
- On Error GoTo 0
- Application.DisplayAlerts = True
- If rRange Is Nothing Then
- Exit Sub
- Else
- rRange.Font.Bold = True
- End If
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement