9
1
I would like the final appearance after my VBA has finished running to be empty of selection -- to have no cell or range on any sheet colored (if it was range selected) or in a bold line box (anything that was selected). Pupose: to present the client with a neat final appearance.
I've searched and cannot find how to do this. There is an Unselect according to MS, but it doesn't seem to do anything.
Why don't you select cell A1 when you save to present a clean look. If you want to strip cell formatting that is a different thing. – wbeard52 – 2012-09-04T00:09:40.393
The cursor has to be somewhere. Why not place it bottom right with
Worksheets("xxxx").Cells(Rows.Count,Columns.Count).Select
or anywhere that is at least a screen away from the used area. – Tony Dallimore – 2012-09-04T08:16:50.670could you just place it back where it was when the macro was called? – SeanC – 2012-09-04T15:45:32.357