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 
. 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