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

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

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