ActiveCell giving blank value
I am having the following code: OSHEET.CELLS(2,3).SELECT MSGBOX OSHEET.CELLS(2,3).VALUE MSGBOX ACTIVECELL.VALUE The cell is having value, but still, its giving the following error: ERROR DESCRIPTION: OBJECT REQUIRED 'ACTIVECELL' i did the following also: MSGBOX ACTIVECELL but its giving me a blank messagebox Please someone help me out in this :confused: . Thanks in advance -- itstome ------------------------------------------------------------------------ itstome's Profile: http://www.excelforum.com/member.php...o&userid=26787 View this thread: http://www.excelforum.com/showthread...hreadid=400412 |
I usually use MSGBOX() with arguments. Try something like:
Sub temp() Dim x As Variant x = Cells(1, 1).Value MsgBox (x) End Sub Good Luck -- Gary's Student "itstome" wrote: I am having the following code: OSHEET.CELLS(2,3).SELECT MSGBOX OSHEET.CELLS(2,3).VALUE MSGBOX ACTIVECELL.VALUE The cell is having value, but still, its giving the following error: ERROR DESCRIPTION: OBJECT REQUIRED 'ACTIVECELL' i did the following also: MSGBOX ACTIVECELL but its giving me a blank messagebox Please someone help me out in this :confused: . Thanks in advance -- itstome ------------------------------------------------------------------------ itstome's Profile: http://www.excelforum.com/member.php...o&userid=26787 View this thread: http://www.excelforum.com/showthread...hreadid=400412 |
All times are GMT +1. The time now is 03:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com