View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Delete Columns and Color Cells

hi
sub iperlovsky()
Sheets("sheet1").Columns("A:AS").ClearContents
End Sub

regards
FSt1

"iperlovsky" wrote:

Would someone be able to provide guidance on how to write a routine to delete
columns A through AS in Sheet 1?