We help IT Professionals succeed at work.

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

glennmgray
glennmgray asked
on
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?  
Comment
Watch Question

Software testing consultant
CERTIFIED EXPERT
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

Author

Commented:
That worked great thanks

Explore More ContentExplore courses, solutions, and other research materials related to this topic.