Menu

Combine 2 columns in a dynamic range into one

Search this Thread

Prev

Previous Post

Next Post

Next

#4

Report Post

Posted to microsoft.public.excel.programming

Claus Busch Claus Busch is offline

Claus Busch is offline

external usenet poster

Posts: 3,872

Default

Combine 2 columns in a dynamic range into one

Hi,

Am Tue, 4 Mar 2014 14:50:21 -0800 (PST) schrieb
:

How would I amend the code to paste the result to the same location in a seperate worksheet names "Lists" ?

try:

Sub Concatenate()
Dim LRow As Long

LRow = Sheets("SquadLists Import").Cells(Rows.Count, 1).End(xlUp).Row

With Sheets("Lists")
.Columns("A").ClearContents
With .Range("A2:A" & LRow)
.Formula = "='Squadlists Import'!A2&"" ""&'Squadlists
Import'!B2"
.Value = .Value
End With
End With

End Sub

Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Reply With Quote

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
Dynamic Range for multiple columns	Robin	Excel Discussion (Misc queries)	8	April 3rd 23 02:26 PM
creating a dynamic range based on criteria, within a dynamic range, and passing it to a function	[email protected]	Excel Programming	0	October 9th 07 05:22 PM
Drawing data from specific columns of a dynamic range	Darren	Setting up and Configuration of Excel	3	March 3rd 06 06:53 AM
Using specific columns of a dynamic range	Darren	Excel Programming	0	March 2nd 06 10:27 AM
Counting Columns in Dynamic Range	ExcelMonkey[_102_]	Excel Programming	1	March 4th 04 10:22 PM

All times are GMT +1. The time now is 01:19 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement