Posted to microsoft.public.excel.programming

external usenet poster

Posts: 519

Compile error, Syntax error

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Bubble sort Error (Compile Error: Type Mismtach)	Excel Monkey[_2_]	Excel Programming	6	April 24th 09 12:16 AM
compile/syntax error to save active book to new location on networ	Sharon	Excel Worksheet Functions	2	March 14th 07 07:51 PM
Syntax and compile error.	Jim15[_16_]	Excel Programming	6	March 27th 06 04:16 PM
VLOOKUP Compile/Syntax Error	JimFor	Excel Programming	4	December 22nd 04 06:10 PM

All times are GMT +1. The time now is 02:04 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us