Posted to microsoft.public.excel.programming

steven

external usenet poster

Posts: 389

Formula = problem

Why does this not work in my macro?

Range("E5").Formula =
"=MID(A8,1+FIND(CHAR(1),SUBSTITUTE(A8,"\",CHAR(1), LEN(A8)-LEN(SUBSTITUTE(A8,"\","")))),255)"

It works fine when the formula it in the cell.

Thank you,

Steven

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
Formula problem	a	Excel Discussion (Misc queries)	1	December 2nd 09 06:20 PM
Formula Problem	Mark Hanson	Excel Discussion (Misc queries)	2	September 12th 07 05:17 PM
Formula problem	superkopite	Excel Discussion (Misc queries)	8	January 27th 06 09:12 PM
formula problem	Bart	New Users to Excel	4	October 21st 05 12:56 PM
Problem with formula	Sundaram Iyer	Excel Discussion (Misc queries)	0	June 1st 05 12:49 AM

All times are GMT +1. The time now is 09:54 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us