Trying to select cell "A1" in excel vba after selecting a range

At the end of an excel vba program I select all the columns being used and set the columns to autofit with the following code:    
 
ActiveSheet.Columns("A:I").Select
Selection.Columns.AutoFit

That however leaves the columns highlighted.  I tried  

Range("A1").Select
Range("A1").Activate                                                

but it didn't have any effect.  If I use

ActiveSheet.Columns("Y:Z").Select

two columns off the screen are highlighted which clears the main area but still leaves another area highlighted.  What I want is to select cell "A1" which when I do it manually clears any highlighting.  Is there any way to do this via vba?  
glennmgrayAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Jeroen RosinkConnect With a Mentor Commented:
Your code should be OK.
Sometimes I have the same issue when the macro is called from another workbook. Then without mentioning to select the activesheet it selects the cell in the workbook in which the code remains.
Though normally this should not make any difference.

Did you try:
ActiveSheet.Range("A1").Select

regards,
Jeroen
0
 
glennmgrayAuthor Commented:
That worked great thanks
0
All Courses

From novice to tech pro — start learning today.