Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to code macro with if condition?
Does anyone have any suggestions on how to code macro with if condition?
My code: myCell.Offset(0,3).Value = Sheets("Temp").Range("B15").Value If Sheets("Temp").Range("B15").Value contains "B" character, then delete "B" and time 1000 with this number, such as 254.63B will become 254630 and assign into myCell.Offset(0,3).Value else If Sheets("Temp").Range("B15").Value contains "M" character, then delete "M", such as 117.46M will become 117.46 and assign into myCell.Offset(0,3).Value Does anyone have any suggestions? Thank you very much for any suggestions Eric |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
code to check condition for each row | Excel Discussion (Misc queries) | |||
Condition Formatting in code. How? | Excel Programming | |||
Condition Formatting in code. How? | Excel Programming | |||
Condition Formatting in code. How? | Excel Programming | |||
Condition added to Sort Code | Excel Programming |