| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error, Syntax error
Thankyou
"AltaEgo" wrote: I suspect you are trying to enter a formula in C2 that works on at cell B2 but I cannot work out exactly what you are trying to achieve with 1+(LEFT(B2)="0"). The alternative way to work out your problem is to physically write the formula in the desired cell then copy it to VBA: ActiveCell.Formula = "yourPastedFormula" or Range("C3").Formula = "yourPastedFormula" HTH -- Steve "Steved" wrote in message ... Hello from Steved I should know but I'm not thinking to clearly. I am getting a Compile error, Syntax error for the below why I thankyou. Sub Removezero() ActiveCell.FormulaR2C3 = "=MID(B2,1+(LEFT(B2)="0"),99)" End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bubble sort Error (Compile Error: Type Mismtach) | Excel Programming | |||
| compile/syntax error to save active book to new location on networ | Excel Worksheet Functions | |||
| Syntax and compile error. | Excel Programming | |||
| VLOOKUP Compile/Syntax Error | Excel Programming | |||
Threaded Mode
