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?
ActiveSheet.Columns("A:I")
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")
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER