hi,
add this line to your code after the clear contents.
Range("A1").select 'or select another cell
or
Cells(1,1).select

regards
FSt1

"SamanthaK" wrote:

I am writing macro that clears the contents of a spreadsheet. After this is
done the whole spreadsheet is selected (it is blue...). How do I write code
so that the spreadsheet is not selected after clear contents is done?
--
I am very thankful for any fast assistance!