Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making Excel understand the diffrence in capitialization?
Hey,
Interesting problem...How do I go about doing this? I need Excel to understand the value of capitalized letters and not automatically replace based on its value... Take a look at code below. Sub Eng_to_code Application.ScreenUpdating = False ActiveCell.Replace What:="A", Replacement:="Ø" ActiveCell.Replace What:="a", Replacement:="-æ-" End Sub Sub Code_to_Eng Application.ScreenUpdating = False ActiveCell.Replace What:="Ø", Replacement:="A" ActiveCell.Replace What:="-æ-", Replacement:="a" End Sub The problem is the code automatically makes the value of the cell into "ØØ" if "Aa" is the active cell value when it should be "Ø-æ-". Any ideas on how to get VB to understand the diffrence of a capital letter? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why doesn't Excel understand what 'Manual' for Calculations? | Excel Discussion (Misc queries) | |||
Does Excel understand Latitude and Longitude (GPS) co-ordinates? | Excel Discussion (Misc queries) | |||
How many workbooks and worksheets can Excel understand? | Excel Discussion (Misc queries) | |||
.01 or .02 diffrence in computation | Excel Discussion (Misc queries) | |||
Project two - Diffrence Sheet | Excel Programming |