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

Try something like

Sheet1.cells(33,"C").Value

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"thuva" wrote in
message ...

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