Re: $$Excel-Macros$$ Re: How to define the uppercase, lowercase and proper()

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

$$Excel-Macros$$ Re: How to define the uppercase, lowercase and proper()

Hi Ashish, Are you there to guide me on the questions below? Thanks On Sunday, April 6, 2014 10:56:23 PM UTC+8, Falina Gan wrote: > > Hi Ashiah, > > Thank you for your advise on the range. Could I ask you some questions as > below:- > > 1) Why do we use If cl.HasFormula = False And Not IsEmpty

$$Excel-Macros$$ Re: How to define the uppercase, lowercase and proper()

Hi Ashiah, Thank you for your advise on the range. Could I ask you some questions as below:- 1) Why do we use If cl.HasFormula = False And Not IsEmpty(cl) And Not IsDate(cl) Then is it that the cell must not be empty and not a date? 2) If a user want to change the whole column rather than

Re: $$Excel-Macros$$ Re: How to define the uppercase, lowercase and proper()

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

$$Excel-Macros$$ Re: How to define the uppercase, lowercase and proper()

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 all the sub function but still can't see the results. Thanks

Re: $$Excel-Macros$$ Re: How to define the uppercase, lowercase and proper()

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

$$Excel-Macros$$ Re: How to define the uppercase, lowercase and proper()

To Whom It May Concern, In VBA please. thanks. On Saturday, April 5, 2014 1:38:03 PM UTC+8, Falina Gan wrote: > > To Whom It May Concern, > > We would like to know if we are creating a column for uppercase, lowercase > and initial case like the image as below: > > >