After the "Find" function in VBA......

I have a Find function used in conjuction with unhiding a sheet, the Find function works, but you have to scroll to find the cell. When you use the "Find" function in Excel it scrolls to the cell and centers it in view, but in the macro it just goes to the cell, but not in view.....any help will be great.

Thanks,

Please Login or Register  to view this content.

End Sub

Please Login or Register  to view this content.

Please Login or Register  to view this content.

=Count_1_incolumnA(A2:A35)