Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am running a loop to obtain values on a change event yet I can not seem to
obtain that value from the sheet I am looking at the values are returning a blank? Private Sub Worksheet_Change(ByVal Target As Range) Dim x As Integer If Target.Address = "$C$13" Then ItemNum = Target.Value Sheets("Data").Select For x = 1 To 10 If Cells(x, 1) = ItemNum Then Desc = Cells(x, 2) StdCost = Cells(x, 3) Spec = Cells(x, 6) End If Next x Sheets("Justification - working").Select Cells(13, 4) = Desc Cells(13, 6) = StdCost Cells(13, 5) = Spec End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help me to first row matching First date and last row matching lastrow | Excel Programming | |||
Matching identical data using data only once in the matching proce | Excel Discussion (Misc queries) | |||
Help with Matching Text Fields - Then Moving the Matching Cells Side by Side | Excel Discussion (Misc queries) | |||
Matching rows in 2 sheets and copying matching rows from sheet 1 t | Excel Programming | |||
Matching data and linking it to the matching cell | Links and Linking in Excel |