'deselecting' cells that have been selected 1

[sue1127]

In Excel 2000, I have a vba macro that selects the worksheet, unhides columns that were previously hidden and saves the spreadsheet under a new name. This is the code:

Cells.Select
Selection.EntireColumn.Hidden = False
ThisWorkbook.SaveAs "C:\Invoices\excel_upload.xls"


The problem is that in the new workbook, the spreadsheet is still selected. It seemed to me that there should be a Cells.Deselect command, but that doesn't seem to be the case. Does anyone know how I can deselect the cells after unhiding the columns and before saving the workbook?

Thanks very much.

Sue

 

[VBAjedi]

AFAIK, there's always SOMEthing selected in an Excel spreadsheet. . . the best fix would be to avoid selecting in the first place. Consolidate your two lines of code into:

Cells.EntireColumn.Hidden = False

And if you do run into selection issues for any reason, you can always select a single cell of your choice:

Range("A1").Select



VBAjedi

 

[sue1127]

Thanks,vbajedi. I combined the two lines of code as you suggested, and it worked