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