Posted to microsoft.public.excel.programming

pete

external usenet poster

Posts: 88

Wrapping text in VBA Code

How do you change this code:

Range("Bcard2").FormulaR1C1 = _
"=IF(card2=1,""A"",if(card2=11,""J"",if(card2=12," "Q"",if
(card2=13,""K"",card2))))"

Into this:

Range("Bcard2").FormulaR1C1 = _
"=IF(card2=1,""A"", _
if(card2=11,""J"", _
if(card2=12,""Q"", _
if(card2=13,""K"",card2))))"

Without getting a complied error stating that excel
expects an "end statement".

Thanks

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
How do I prevent a long string of text from wrapping in a text fil	stevekaz21	Excel Discussion (Misc queries)	1	October 23rd 09 03:46 PM
Text wrapping	Gary''s Student	Excel Discussion (Misc queries)	1	February 27th 09 10:03 AM
Wrapping Text	TÃ©	Excel Discussion (Misc queries)	1	January 23rd 08 03:01 PM
text wrapping when text is pasted in excel	psipg	Excel Discussion (Misc queries)	2	December 5th 06 07:25 PM
I am using wrap text in excel, so why isn't all my text wrapping?	GatorDawg123	Excel Discussion (Misc queries)	2	May 6th 06 05:52 PM

All times are GMT +1. The time now is 09:41 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us