99.9% of the time there will be absolutely no difference. Using the word
Excel more fully resolves the object. Range in this case is a part of the
Excel object. If you had referenced something else which had Range as a key
word then you would need this to specify what type of range you were refering
to.
--
HTH...
Jim Thomlinson
"Piranha" wrote:
Hi,
Is there any difference in these two statements??
What does the word "Excel." do??
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Private Sub Worksheet_Change(ByVal Target As Range)
Thx
Dave
--
Piranha
------------------------------------------------------------------------
Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435
View this thread: http://www.excelforum.com/showthread...hreadid=376118