-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
target.row.value
-
M
2 VBA codes in one sheets
Hi, I'm currently using the following simple code in my worksheet. It's simply changing the status of a job if another columns status changes. Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("C:C")) Is Nothing Then Range("B" & Target.Row).Value = Now...- MKDC1303
- Thread
- end intersecttarget job rangeo target.row.value
- Replies: 7
- Forum: Excel Questions
-
S
My second part of code is about populating no of months in G cell when no of days Is given in F cell and vice versa. But it throws run time error 13 w
Private Sub Worksheet_Change(ByVal Target As Range) ' If the target column is greater than J And J isn't blank And K is blank then... If Target.Column > 9 And (Range("C" & Target.Row).Value = "CP" Or Range("C" & Target.Row).Value = "NCD") And (Range("I" & Target.Row).Value = "" Or Range("I" &...- Sathishky
- Thread
- blank error rangei target target.row.value
- Replies: 0
- Forum: Excel Questions
-
T
Remaining balance
Hi, I’m really struggling to calculate the remaining balance for a given country, product range, warehouse and production month and incorporate in my existing code (see below). Each time the user is doing some changes in the worksheet “Main”, they are listed under the worksheet “Tracking”...- TG2812
- Thread
- balance range remaining sheetstracking.rangea target.row.value
- Replies: 0
- Forum: Excel Questions
