Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi, I run the following macro to convert columns E,G,H,I into Euro's but it
keeps converting coulmn D, which I don't won't to convert. Can anyone help. Thanks If Range("D7") = "EURO" Then Range("E:E,G:G,H:H,I:I").Select Selection.NumberFormat = "[$ぎ-2] #,##0.00;[Red]-[$ぎ-2] #,##0.00" Range("A1").Select End If |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with copy and paste together with macros | Excel Worksheet Functions | |||
tough problem, maybe macros will solve it | New Users to Excel | |||
Problem Assigning Macros | Excel Worksheet Functions | |||
Problem with running Macros | Excel Discussion (Misc queries) | |||
problem:search results negative in excel docs with macros | Excel Discussion (Misc queries) |