I have a worksheet having data to column AMR. When I make columns shown and hidden several time using VBA, the horizental scroll bar of Excel has a problem as followed:
1. To see the column AMR, I have to drag the scroll bar very little (left image).
2. If I put the scroll bar right-most position, I become to hit column UVT (right image). There is no data from columns AMS to UVT.
How can I reset my worksheet shows column AMR when I put the scroll bar right-most position? Worksheet.ScrollArea is not of solution. I already tested with no result.
Reply would be appreciated.