Macro Function

[thuva]

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

 

[Bob Phillips]

Try something like

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

--
HTH

Bob Phillips

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