|
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 |
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 |
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 |
| All times are GMT +1. The time now is 10:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com