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
|