我在VBA中要选择一区域,如xlSheet.Rows("5:19").Select;但现在问题是:其中的区域起始行和最后行是需要用参数传递的,如: ......
xlSheet.Cells.Find(What:="Soll", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False).Activate
CurrCellRow1 = xlSheet.Cells.Row xlSheet.Cells.Find(What:="Work", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False).Activate
CurrCellRow2 = xlSheet.Cells.Row 如果我要将变量CurrCellRow1及CurrCellRow2传给xlSheet.Rows("5:19").Select。我应该如何处理?谢谢各位!
xlSheet.Cells.Find(What:="Soll", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False).Activate
CurrCellRow1 = xlSheet.Cells.Row xlSheet.Cells.Find(What:="Work", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False).Activate
CurrCellRow2 = xlSheet.Cells.Row 如果我要将变量CurrCellRow1及CurrCellRow2传给xlSheet.Rows("5:19").Select。我应该如何处理?谢谢各位!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货