In the module code,i want to write a code with using IF functions.
for that i need to check Sheet cell values.
when i write within a function like this

Sheet.cells([33],[C]) to refer the cell value
excel returns a error #value.
How i can refer a cell in a sheet in macro.
i am willing to write this with out introducing a user form.
thuva


--
thuva
------------------------------------------------------------------------
thuva's Profile: http://www.excelforum.com/member.php...o&userid=36789
View this thread: http://www.excelforum.com/showthread...hreadid=565020