| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine the type of currency in a cell
Hi!
I have an excel sheet where some cells are formated as Currency Euro others as Currency Brittish Pund and others as Currency American Dollars. I would now like, in Vba, to determine what type of currency a specific cell is containing. Is that possible? I'm looking for some thing like: Range(A1).CurrencyType=Euro Any suggestions are appreciated. Thanks Anders --- Message posted from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I type in a number in a cell but it wont convert to currency help | Excel Worksheet Functions | |||
| How to add new currency Symbol in Format/Cell/Currency | Excel Discussion (Misc queries) | |||
| Default display format for "currency" data type | Excel Discussion (Misc queries) | |||
| When I type numbers in currency all I get is ####### | Excel Discussion (Misc queries) | |||
| Determine File Type | Excel Programming | |||
![Anders[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
