View Single Post
  #1   Report Post  
itstome
 
Posts: n/a
Default ActiveCell giving blank value in vbscript


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