Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to paste 2 variables value in a cell
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 *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to paste 2 variables value in a cell
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? cliee cliee wrote in message ... 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 *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to paste 2 variables value in a cell
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 -- Regards, Tom Ogilvy "cliee cliee" wrote in message ... 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 *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using variables within a formula in the same cell. | Excel Discussion (Misc queries) | |||
Need Destination cell to ref origin cell, but w/ many variables..H | Excel Worksheet Functions | |||
Using variables in a cell/formula | Excel Worksheet Functions | |||
Paste Link enters a 0 into the cell where I paste. How do I elemin | Excel Discussion (Misc queries) | |||
variables in last cell | Excel Programming |