How to check one cell value to diffrent cell
 

How to check one cell value to diffrent cell and check the condition and if
fulfils the condition than return a value from a different cell to the cell
we Started comparing

How to check one cell value to diffrent cell
 

Care to explain.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Adarsh Nath" <Adarsh wrote in message
...
How to check one cell value to diffrent cell and check the condition and
if
fulfils the condition than return a value from a different cell to the
cell
we Started comparing

How to check one cell value to diffrent cell
 

dim Cell1 as range
dim Cell2 as range
dim cell3 as range

set cell1 = somecellinyourcode1
set cell2 = somecellinyourcode2
set cell3 = somecellinyourcode3

if cell1.value = cell2.value then
cell1.value = cell3.value
end if


Adarsh Nath wrote:

How to check one cell value to diffrent cell and check the condition and if
fulfils the condition than return a value from a different cell to the cell
we Started comparing

--

Dave Peterson