Posted to microsoft.public.excel.programming

Marc[_26_] Marc[_26_] is offline

external usenet poster

Posts: 14

FormulaR1C1

I have vfp code like below
loExcelSession.Cells(1,11).FormulaR1C1 =
ALLTRIM(STR(loExcelSession.Cells(1,11).Value))
Is there anyway to update the entire column at once?

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
What Does FormulaR1C1 Do?	Don Guillett	Excel Programming	0	December 14th 06 10:33 PM
Formular1c1	Steph[_3_]	Excel Programming	2	June 30th 05 09:12 PM
FormulaR1C1	Aksel Børve	Excel Programming	2	February 28th 05 09:52 PM
FormulaR1C1	D.S.[_3_]	Excel Programming	2	January 2nd 04 12:03 AM
FormulaR1C1	aapp81[_22_]	Excel Programming	3	December 3rd 03 10:47 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us