Posted to microsoft.public.excel.programming

hoysala

external usenet poster

Posts: 11

code for a formula

HI

Can anybody help me write a macro code for this?

For i = 5 To Cells(39, 2).Value
Cells(3, i).Value = MID(TEXT(B37+k ,"dddd"),1,3)
k = k + 1
Next i

My problem is that i am not able to write a code for formula.

thank you

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
Using formula in code	Alan M	Excel Programming	1	August 17th 07 02:09 AM
Using formula in code	Halim	Excel Programming	0	August 17th 07 01:45 AM
Formula in code	jln via OfficeKB.com	Excel Programming	2	July 13th 07 03:02 PM
Have a Formula I want to put in to some Code Q	John	Excel Programming	2	June 5th 04 04:39 PM
SUM Formula using code	Sony[_2_]	Excel Programming	1	August 27th 03 09:34 AM

All times are GMT +1. The time now is 06:11 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us