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

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