ActiveCell giving blank value

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