ExcelBanter - Delete Columns and Color Cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Delete Columns and Color Cells (https://www.excelbanter.com/excel-discussion-misc-queries/193322-delete-columns-color-cells.html)

iperlovsky

Delete Columns and Color Cells

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

FSt1

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?

iperlovsky

Delete Columns and Color Cells

Great. Thx!

"FSt1" wrote:

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?

All times are GMT +1. The time now is 06:36 PM.