Multiple cell information into 1 cell

[Wes]

Hi all,

What I am attempting to do is have information from several different cells copied into a single cell. Below is the formula I am using but obviously I'm missing the bus on this one.

Any guidence would really be appreciated.


Worksheets("Morning Report").Range("D19").Value = ActiveSheet.Range("k8" & "k10").Value

Wes

 

[Scott Huish]

How about:

Worksheets("Morning Report").Range("D19").Value = ActiveSheet.Range("K8").Value & Activesheet.Range("K10").Value

 

[HalfAce]

Hi Wes,
Try this:

Worksheets("Morning Report").Range("D19") = ActiveSheet.Range("k8").Value & ActiveSheet.Range("k10").Value

If you want a space between those two values then use:

Worksheets("Morning Report").Range("D19").Value = ActiveSheet.Range("k8").Value& " " &ActiveSheet.Range("k10").Value

Dan

Edit: Too slow again...

 

[Wes]

HotPepper

A 100%, thanks.



Wes