Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CONCATENATE problem with blank cells | Excel Discussion (Misc queries) | |||
Counting blank and filled cells within a range. | Excel Discussion (Misc queries) | |||
How to delete blank rows | Excel Discussion (Misc queries) | |||
blank cells | Excel Discussion (Misc queries) | |||
VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions |