View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_4_] Jim Thomlinson[_4_] is offline
external usenet poster
 
Posts: 1,119
Default Target As Excel.Range or Target As Range

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