Screen Refresh

[Giordano Bruno]

Hi Everybody,

I have some VBA code which takes the user back to the main sheet. Somehow the activecell is not indicated with the usual border when the macro finishes.

When I click on another cell, that border is shown together with one on the new active cell. I get the appearance of two active cells until I click on the first one again and then I have the appearance of no active cells.

I think the best solution is to get the screen to refresh. I can do this with Page Down, Page Up, but there must be a better way to make the screen refresh and fix itself.

Any help most gratefully received.

 

[zzjasonzz]

You could probably just add ActiveCell.Select into the code at the end or range("A1").select

 

[Giordano Bruno]

Thanks zzjasonzz,

I tried that and it gives me the top border, but not the two sides and bottom.

It seems to be a bit of a bug and I just need a workaround. Maybe Page up and Page Down in the solution.