Delete Columns and Color Cells

  • Thread starter Thread starter iperlovsky
  • Start date Start date
I

iperlovsky

Would someone be able to provide guidance on how to write a routine to delete
columns A through AS in Sheet 1?
 
hi
sub iperlovsky()
Sheets("sheet1").Columns("A:AS").ClearContents
End Sub

regards
FSt1
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete columns 5
"cannot shift objects off sheet" error 8
Counting and deleting 7
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel VBA 1
Comparing text in columns 18
How to filter rows data based on background color of individual cells 1

Back
Top