PDA

View Full Version : How to unselect the selected data ?!?



vodkasoda
01-11-2012, 03:23 AM
Hopefully very quick & easy for somebody ... I receive an E:Mailed Zip file on a regular basis, within which are a number of files. One is called Test.rtf & I have to work from it, but not save it, I just access data from it. It is easier for me to use when in Landscape, so I run the following code against it as soon as I open it, but I can't UnSelect the data, how do I do this please ?!?

Sub KA_Test_Formatter()
'
' KA_Test_Formatter Macro
'
'

Application.ScreenUpdating = False

Selection.WholeStory

With Selection
.Font.Name = "Courier New"
.Font.Size = 8
.PageSetup.Orientation = wdOrientLandscape
End With

Selection.??? <<< Here, how do I UnSelect the data ?

Application.ScreenUpdating = True

End Sub

vodkasoda
01-11-2012, 03:43 AM
Selection.StartOf works just fine ...

How do I close this thread, or mark it as resolved ?!?

fumei
01-20-2012, 08:54 PM
1. using Selection - at all - for this is very inefficient

2. Selection.Collapse collapses the Selection, essentially unselecting

Paul_Hossler
01-21-2012, 05:24 AM
:bigdance2
fumei

You're back ... I hope

I was pleasantly surprised to see you pop up on a thread after so long

Hasn't been the same without you

Paul

fumei
01-25-2012, 08:01 PM
I am still basically off-line - I have no home internet connection (and am no longer working) - so will only be in and out once in a while.