| Home |
| Search |
| Today's Posts |
|
#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! |
| 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 | |||
Threaded Mode
