Posted to microsoft.public.excel.programming

SteveDB1

external usenet poster

Posts: 414

if elseif....

Bingo!
Thanks Per.
That did it.
Best.

"Per Jessen" wrote:

Hello again Steve

I think this is what you want:

If NewString = "" Then
NewString = MyRng.Cells(cell, 1).Value
ElseIf MyRng.Cells(cell, 1).Value < "" Then
NewString = NewString & vbLf & MyRng.Cells(cell, 1).Value
End If

Best regards,
Per

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
elseif	Tom Ogilvy	Excel Programming	3	March 28th 07 03:03 AM
IF..Then..ELSE.. ELSEIF	ole_	Excel Programming	4	April 20th 05 03:59 PM
If, ElseIf	mast	Excel Programming	1	January 26th 05 12:11 PM
ElseIf	tom1646	Excel Programming	4	October 19th 04 02:09 PM
If...Elseif...End If	javab98	Excel Programming	2	July 19th 04 07:23 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us