Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Explanation of code
Hi, I am pretty new to vb and I was wondering if somebody could explai me how this code works: Private Sub Worksheet_Change(ByVal Target As Range) Dim temp As Range Set temp = Intersect(Target, Range("H3:H16")) If temp Is Nothing Then Else Target.Offset(0, -1) = Target.Offset(0, -1) - Target End If End Sub what does 'Target As Range' mean and how can 'Target' be something i we dont input anything? Also explain the intersect function please. Thanks a lot guys. Regards, Marco ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Explanation of code
Hi Marcos
The WorksheetChange is a predefined event, the macro runs when cells are changed. We don't input anything, Excel does herself. She inputs Target, which is the cell or the cells that just changed content. A range is one or more cells. Target is a range, H3:H16 is another. Intersect is the cells that those two ranges have in common. If you change (for example by Paste) the cells C4:N4 then this is Target and cell H4 is the cell that is exist both ranges, it's "intersect". If Intersect is nothing then Target has nothing to do with H3:H16, otherwise an action is performed. -- HTH. Best wishes Harald Followup to newsgroup only please "marksuza" skrev i melding ... Hi, I am pretty new to vb and I was wondering if somebody could explain me how this code works: Private Sub Worksheet_Change(ByVal Target As Range) Dim temp As Range Set temp = Intersect(Target, Range("H3:H16")) If temp Is Nothing Then Else Target.Offset(0, -1) = Target.Offset(0, -1) - Target End If End Sub what does 'Target As Range' mean and how can 'Target' be something if we dont input anything? Also explain the intersect function please. Thanks a lot guys. Regards, Marcos ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Explanation of code
Thanks for the help ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Explanation of when & how to use ( ) { } : ; , ! etc? | New Users to Excel | |||
Foremula Explanation | Charts and Charting in Excel | |||
A better explanation of help required | Excel Discussion (Misc queries) | |||
Quick Explanation | Excel Worksheet Functions | |||
Comma explanation | Excel Worksheet Functions |