UCase function
Returns a Variant (String) containing the specified string, converted
to uppercase.
Syntax: UCase(string)
Example
Range A10 contain text data : "tOtaL Cost"
x = UCase(Left(Range("A10")),5)
return x = "TOTAL"
x = Left(Range("A10"),5)
returns x = "tOtaL"
comparing
UCase(Left(Range("A10")),5) = "TOTAL"
returns TRUE
comparing
Left(Range("A10")),5) = "TOTAL"
returns FALSE
CMIIW
best rgds
siti
On May 14, 12:50 am, John Whetstone <johnw...@gmail.com> wrote:
> Thanks for the code... I am trying it out.... it all makes sense to me,
> except "UCase" -- what is it? It's not a function... and when I run this
> code , nothing happens -- can you explain a little more? Sorry, but I am a
> novice...
>
> On Wed, May 12, 2010 at 6:55 PM, siti Vi <villager.g...@gmail.com> wrote:
> > Sub Bla_Bla_Bla()
> > Dim MyRng As Range, n As Long
> > Set MyRng = ActiveSheet.UsedRange
>
> > For n = MyRng.Rows.Count To 1 Step -1
> > If UCase(Left(Trim(MyRng(n, 1)), 5)) = "TOTAL" _
> > Then MyRng(n + 1, 1).EntireRow.Insert
> > Next
>
> > End Sub
>
> > NOTE:
> > to insert a row you have to say the range object first:
> > RangeObject.EntireRow.Insert
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
