1- yes to avoid blank cells n formula's
2 you can try For Each cl In Range("a1:a100")
3 is it small -upper sequence?
On Mon, Apr 7, 2014 at 8:59 PM, Falina Gan wrote:
> Hi Ashish,
>
> Are you there to guide me on the questions below?
>
> Thanks
>
>
> On Sunday, April 6, 2014 10:56:23 PM UTC+8
you need to select the range and then run proper, upper , lower etc as per
your requirement
On Sat, Apr 5, 2014 at 9:54 PM, Falina Gan wrote:
> Hi Ashish,
>
> Good day,
>
> I have tested your codes but the texts are not changes at all. The macro
> have asked me which one to run and I have run
Sub propercase()
Dim cl As Range
For Each cl In Selection.Cells
If cl.HasFormula = False And Not IsEmpty(cl) And Not IsDate(cl) Then
cl = StrConv(cl.Text, vbProperCase)
End If
Next
End Sub
Sub uppercase()
Dim cl As Range
For Each cl In Selection.Cel
