how to paste 2 variables value in a cell

[cliee]

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

 

[Guest]

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

 

[cliee cliee]

I want to make a condition ( if the cell is empty) to do something......

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

value = 0 do not mean the cell is empty

do you know how ?

thanks

 

[R.VENKATARAMAN]

this may be a solution if you want to avoid vba

if your target cell is C7, type in C8
=IF(C7="",0)
then copy C8 to C7
if C7 has somevalue the C8 will give "false"

is this what you want?

 

[Tom Ogilvy]

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

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

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