Special Characters
in [Programming]
|
Prev: Does Excel 2003 or 2007 have a Report Manager Add In
Next: To enter data in columns in required order in some special way and to ensure this
From: BillR on 16 Apr 2010 16:41 I do any programming by recording macros and then trying to adapt them to fit my situation. I frequently run into unexplored territory. I need to know where to find how to use ampersands, periods, quotes, etc. Any help would be greatly appreciated. thanks. -- BillR
From: ryguy7272 on 16 Apr 2010 17:30 I don't think there is a specific answer for this. Just trial and error, school of hard knocks, lots and lots of practice, etc. You can read books, and read through posts here. Read as many posts as you have time for. Try to answer some questions too!! You may be surprised about how much you learn!!!! -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "BillR" wrote: > I do any programming by recording macros and then trying to adapt them to fit > my situation. I frequently run into unexplored territory. I need to know > where to find how to use ampersands, periods, quotes, etc. > Any help would be greatly appreciated. > thanks. > -- > BillR
From: Project Mangler on 17 Apr 2010 04:32
Hi Bill, For ampersand look up "operator summary" in Microsoft Visual Basic Help (use ALT + F11 and select help ) and look under "concatenation operators". Basically it is a way of adding strings i.e. "A" & "B" gives "AB" Periods are used to create compound VBA commands e.g. Range("A1").Select will select cell A1 by using the range property in conjunction with the select method joined by a period Double quotes are used to surround strings. If you look at VBA help you will see examples of its use. This is from the Select Method help: Worksheets("Sheet1").Activate where Sheet1 is being activated by code. There are some great websites out there and I've learnt by borrowing code from them and adapting it and trying to figure out how it works. Unfortunately there is a lot to learn, but I guess thats why VBA is so versatile. HTH "BillR" <BillR(a)discussions.microsoft.com> wrote in message news:E028D873-80D1-494F-AFB4-43905A82FFD8(a)microsoft.com... > I do any programming by recording macros and then trying to adapt them to fit > my situation. I frequently run into unexplored territory. I need to know > where to find how to use ampersands, periods, quotes, etc. > Any help would be greatly appreciated. > thanks. > -- > BillR |