[color=darkblue]Sub[/color] ham(sh [color=darkblue]As[/color] Worksheet)
sh.Select
[color=darkblue]End[/color] [color=darkblue]Sub[/color]
[color=darkblue]Sub[/color] test()
ham sh:=Sheet2
[color=darkblue]End[/color] Sub
vumian đã viết:hi,
Minh code cái này
sub ham(sh as sheet) hoặc worksheets
sh.select
end sub
ham (sheet1)
hay call ham (sheet1)
đều bị báo lỗi, hichic
Cám ơn giúp dỡ
Sub ham(sh As Worksheet)
With sh
.Visible = xlSheetVisible
.Select
End With
End Sub
'-------------------------------------------
Sub test()
ham Sheet1
End Sub