View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default how to paste 2 variables value in a cell

Hi
try:
Worksheets("Label-s").Range("A7").Value = "the price is" & art & " " & des

"cliee" wrote:

Hi I am a beginner of excel programmer
I do not know many things on excel commands

I want to copy 2 variables,
eg. art and des
and then paste their value in a cell
eg. art & des

art = ActiveCell(1, 1).Value
des = ActiveCell(1, 3).Value

If ActiveSheet.Range("A6").Value = 0 Then

Worksheets("Label-s").Range("A7").Value.select
"the price is" & art & des.Paste
End If

I don't know who to do this

Many thanks for your help