Excel, strange this is working

strange this is working

Author	Message
Ron de Brui #1 / 7	strange this is working Hi all By coincident I found that this subs are working. It is strange because the upper and lower don't work and the proper does. ltrim not and trim does?? Are there more things like this??? Regards Ron Sub a() Selection.Value = Application.Trim(Selection.Value) End Sub Sub b() Selection.Value = Application.Proper(Selection.Value) End Sub Sub c() Selection.Value = Application.Dollar(Selection.Value) End Sub
Thu, 08 Jul 2004 04:19:13 GMT

Dave Peterso #2 / 7	strange this is working If you look in the help for worksheetfunctions available in VBA, you'll see that the 3 you mention are all available in VBA. But Upper/lower are not. Maybe because VBA has it's own Ucase and LCase functions (along with strconv) that do the same thing (except that they all act on one item). Trim also is in both VBA and excel proper, but it does slightly different things (The worksheet function removes consecutive spaces within the string, while the vba function does not.) === But to your bigger point, it would be nice to be able to do things like: selection.value = Ucase(selection.value) or selection = ucase(selection) for ranges with more than one cell. I don't have an answer why it doesn't work. Quote: > Hi all > By coincident I found that this subs are working. > It is strange because the upper and lower don't work and the proper does. > ltrim not and trim does?? > Are there more things like this??? > Regards Ron > Sub a() > Selection.Value = Application.Trim(Selection.Value) > End Sub > Sub b() > Selection.Value = Application.Proper(Selection.Value) > End Sub > Sub c() > Selection.Value = Application.Dollar(Selection.Value) > End Sub -- Dave Peterson
Thu, 08 Jul 2004 05:14:19 GMT

Orlando Magalh?es Filh #3 / 7	strange this is working Hi Ron, Proper and Trim are worksheet functions available for VBA and upper, lower and Ltrim not for this you have Ucase, LCase and Ltrim VBA functions. Selection.Value = Ucase(Selection.Value) Selection.Value = Lcase(Selection.Value) Selection.Value = Ltrim(Selection.Value) HTH Quote: > Hi all > By coincident I found that this subs are working. > It is strange because the upper and lower don't work and the proper does. > ltrim not and trim does?? > Are there more things like this??? > Regards Ron > Sub a() > Selection.Value = Application.Trim(Selection.Value) > End Sub > Sub b() > Selection.Value = Application.Proper(Selection.Value) > End Sub > Sub c() > Selection.Value = Application.Dollar(Selection.Value) > End Sub
Thu, 08 Jul 2004 06:08:43 GMT

Ron de Brui #4 / 7	strange this is working I try this already Orlando but give me a error ( error 13) Do you now why Quote: > Hi Ron, > Proper and Trim are worksheet functions available for VBA and upper, lower > and Ltrim not for this you have Ucase, LCase and Ltrim VBA functions. > Selection.Value = Ucase(Selection.Value) > Selection.Value = Lcase(Selection.Value) > Selection.Value = Ltrim(Selection.Value) > HTH > > Hi all > > By coincident I found that this subs are working. > > It is strange because the upper and lower don't work and the proper does. > > ltrim not and trim does?? > > Are there more things like this??? > > Regards Ron > > Sub a() > > Selection.Value = Application.Trim(Selection.Value) > > End Sub > > Sub b() > > Selection.Value = Application.Proper(Selection.Value) > > End Sub > > Sub c() > > Selection.Value = Application.Dollar(Selection.Value) > > End Sub
Thu, 08 Jul 2004 07:00:55 GMT

Dave Peterso #5 / 7	strange this is working Your selection contained more than one cell. Quote: > I try this already Orlando > but give me a error ( error 13) > Do you now why > > Hi Ron, > > Proper and Trim are worksheet functions available for VBA and upper, lower > > and Ltrim not for this you have Ucase, LCase and Ltrim VBA functions. > > Selection.Value = Ucase(Selection.Value) > > Selection.Value = Lcase(Selection.Value) > > Selection.Value = Ltrim(Selection.Value) > > HTH > > > Hi all > > > By coincident I found that this subs are working. > > > It is strange because the upper and lower don't work and the proper > does. > > > ltrim not and trim does?? > > > Are there more things like this??? > > > Regards Ron > > > Sub a() > > > Selection.Value = Application.Trim(Selection.Value) > > > End Sub > > > Sub b() > > > Selection.Value = Application.Proper(Selection.Value) > > > End Sub > > > Sub c() > > > Selection.Value = Application.Dollar(Selection.Value) > > > End Sub -- Dave Peterson
Thu, 08 Jul 2004 09:14:38 GMT

Ron de Brui #6 / 7	strange this is working yes I now Dave So it is not the same Orlando posted Selection.Value = Application.Proper(Selection.Value) will work on more then one cell Regards Ron Quote: > Your selection contained more than one cell. > > I try this already Orlando > > but give me a error ( error 13) > > Do you now why > > > Hi Ron, > > > Proper and Trim are worksheet functions available for VBA and upper, lower > > > and Ltrim not for this you have Ucase, LCase and Ltrim VBA functions. > > > Selection.Value = Ucase(Selection.Value) > > > Selection.Value = Lcase(Selection.Value) > > > Selection.Value = Ltrim(Selection.Value) > > > HTH > > > > Hi all > > > > By coincident I found that this subs are working. > > > > It is strange because the upper and lower don't work and the proper > > does. > > > > ltrim not and trim does?? > > > > Are there more things like this??? > > > > Regards Ron > > > > Sub a() > > > > Selection.Value = Application.Trim(Selection.Value) > > > > End Sub > > > > Sub b() > > > > Selection.Value = Application.Proper(Selection.Value) > > > > End Sub > > > > Sub c() > > > > Selection.Value = Application.Dollar(Selection.Value) > > > > End Sub > -- > Dave Peterson
Thu, 08 Jul 2004 17:34:50 GMT

Dave Peterso #7 / 7	strange this is working Orlando's formula used the VBA functions. It sure looks like the worksheet function is more useful(?) when converting a multi-cell range. But not all worksheet functions work inside VBA. This looks to me like one of those things I'll kind of remember. I'll have to try it each time I use it to see which ones work what way. Quote: > yes I now Dave > So it is not the same Orlando posted > Selection.Value = Application.Proper(Selection.Value) > will work on more then one cell > Regards Ron > > Your selection contained more than one cell. > > > I try this already Orlando > > > but give me a error ( error 13) > > > Do you now why > > > > Hi Ron, > > > > Proper and Trim are worksheet functions available for VBA and upper, > lower > > > > and Ltrim not for this you have Ucase, LCase and Ltrim VBA functions. > > > > Selection.Value = Ucase(Selection.Value) > > > > Selection.Value = Lcase(Selection.Value) > > > > Selection.Value = Ltrim(Selection.Value) > > > > HTH > > > > > Hi all > > > > > By coincident I found that this subs are working. > > > > > It is strange because the upper and lower don't work and the proper > > > does. > > > > > ltrim not and trim does?? > > > > > Are there more things like this??? > > > > > Regards Ron > > > > > Sub a() > > > > > Selection.Value = Application.Trim(Selection.Value) > > > > > End Sub > > > > > Sub b() > > > > > Selection.Value = Application.Proper(Selection.Value) > > > > > End Sub > > > > > Sub c() > > > > > Selection.Value = Application.Dollar(Selection.Value) > > > > > End Sub > > -- > > Dave Peterson -- Dave Peterson
Thu, 08 Jul 2004 22:34:26 GMT

Page 1 of 1

[ 7 post ]