Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Special Characters
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Special Characters
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Special Characters
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
special Characters | Excel Discussion (Misc queries) | |||
Special Characters | Excel Worksheet Functions | |||
Special Characters | Excel Discussion (Misc queries) | |||
Special characters | Excel Discussion (Misc queries) | |||
special characters (little box) | Excel Discussion (Misc queries) |