Link to home
Start Free TrialLog in
Avatar of glennmgray
glennmgray

asked on

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?  
ASKER CERTIFIED SOLUTION
Avatar of Jeroen Rosink
Jeroen Rosink
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of glennmgray
glennmgray

ASKER

That worked great thanks