ActiveCell giving blank value

  • Thread starter Thread starter itstome
  • Start date Start date
I

itstome

I am having the following code:

OSHEET.CELLS(2,3).SELECT
MSGBOX OSHEET.CELLS(2,3).VALUE
MSGBOX ACTIVECELL.VALU

The cell is having value, but still, its giving the following error:
ERROR DESCRIPTION: OBJECT REQUIRED 'ACTIVECELL

i did the following also:
MSGBOX ACTIVECEL

but its giving me a blank messagebox

Please someone help me out in this :confused: . Thanks in advanc
 
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
 
Back
Top