| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Target As Excel.Range or Target As Range
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Target As Excel.Range or Target As Range
Jim, Thank you very much for your explanation. It is very good. Thx again Dave Jim Thomlinson Wrote: 99.9% of the time there will be absolutely no difference. Using th word Excel more fully resolves the object. Range in this case is a part o the Excel object. If you had referenced something else which had Range as key word then you would need this to specify what type of range you wer 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 -- Piranh ----------------------------------------------------------------------- Piranha's Profile: http://www.excelforum.com/member.php...fo&userid=2043 View this thread: http://www.excelforum.com/showthread.php?threadid=37611 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Private Sub Worksheet_Change(ByVal Target As Excel.Range) | Excel Programming | |||
| Private Sub Worksheet_Change(ByVal Target As Excel.Range) | Excel Worksheet Functions | |||
| Ranges:Target in Worksheet_SelectionChange(ByVal Target As Range) | Excel Programming | |||
| Multiple Target as Excel Range | Excel Programming | |||
| Excel VBA .... Worksheet_Change(ByVal Target As Range) question | Excel Programming | |||
![Piranha[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
