Archives

Excel Programming – VBScript Advanced

Creating a VBScript to update tables from a spreadsheet: For RowCount = 2 To Worksheets(“Data”).UsedRange.Rows.Count() + 1 If Worksheets(“Data”).Cells(RowCount, 1) = cmbYear.Text Then For tables = 0 To 2 If Worksheets(“Data”).Cells(RowCount, 6) = servicetypes(tables) Then For brands = 0 To 4 If Worksheets(“Data”).Cells(RowCount, 5) = arrbrands(brands) Then For salestage = 0 To 2 If CInt(Left(Worksheets(“Data”).Cells(RowCount, […]

Rate this:

Read More