设要查找A列排名前五的5个数值,放在B列B1开始的位置:
Sub 宏1()For i = 1 To 5 Cells(i, 2) = Application.Large(Columns("A"), i)NextEnd Sub
设要查找A列排名前五的5个数值,放在B列B1开始的位置:
Sub 宏1()For i = 1 To 5 Cells(i, 2) = Application.Large(Columns("A"), i)NextEnd Sub
Copyright © 2018 - 2021 www.yd166.com., All Rights Reserved.