![]() ![]() ' Set Rng as the cell where "Admin No." is found ![]() Set sRange = Sheets("SABER").Range("A1", Cells(1, LastCol)) ' Sets the search range as A1 to the last column with a header on the Run sheet LastCol = Sheets("SABER").Cells(1, Columns.Count).End(xlToLeft).Column ' Defines LastCol as the last column with a header on the Run sheet VBA macrosĬan someone help me with the following script? There is something wrong with the last call function of this.ĭim Cell As Range, sRange As Range, Rng As Range
0 Comments
Leave a Reply. |