$$Excel-Macros$$ Re: Concatenate Macro

2009-04-07 Thread Steve
Exactly what I was looking for Thanks, Steve On Apr 7, 5:55 am, Dave Bonallack wrote: > Hi Steve, > Try this code. It assumes data is in Columns A and B, as stated, and that the > data starts in Row 2. > > Sub Steve() >     Application.ScreenUpdating = False >     A = 2 >     B = 2 >     C

$$Excel-Macros$$ Re: Concatenate Macro

2009-04-07 Thread Dave Bonallack
Hi Steve, Try this code. It assumes data is in Columns A and B, as stated, and that the data starts in Row 2. Sub Steve() Application.ScreenUpdating = False A = 2 B = 2 C = 2 For i = 1 To 100 Do Until Cells(A + 1, 1) <> "" Cells(B, 2) = WorksheetFunction.t

$$Excel-Macros$$ Re: Concatenate Macro

2009-04-06 Thread Rajat Jain
hello Steve , try this = concatenate( Box with, Cover and,4 slotted sides) u can there by combined all the above rows into one alternatively =concatenate(rowc2,rowc3, rowc4) will give the required result thankx n regards Rajat Jain kolkata rajatv...@gmail.com On Tue, Apr 7, 2009 at

$$Excel-Macros$$ Re: Concatenate Macro

2009-04-06 Thread Norman May
Steve, You can do it with a simple formula if you want: If you have data in cell A2 and B2 you want to join, the following formula will work: =A2&" "&B2 Then you can copy and paste special (Values) Norman On Mon, Apr 6, 2009 at 4:55 PM, Steve wrote: > > Hi, > > I could really use some help

$$Excel-Macros$$ Re: Concatenate Macro

2009-04-06 Thread Paul Schreiner
Is it something you have to do often? or is it one time? It could be done with a formula, but if it has to be done often, then it would be better with a macro. pretty easy with a macro... Paul From: Steve To: MS EXCEL AND VBA MACROS Sent: Monday, April 6,