View Single Post
  #1   Report Post  
itstome
 
Posts: n/a
Default 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 . 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