Macro Function
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 |
Macro Function
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 |
All times are GMT +1. The time now is 10:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com