View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Benjamin Bob Benjamin is offline
external usenet poster
 
Posts: 23
Default How do I delete rows and columns in With With End Loop?

How do I have to modify the loop below in order
to delete columns A to H and rows 1 to 59 in wbk2?

With wbk2.Sheets(1)
.Cells.ClearFormats
.Cells(1, 1).Select
.Columns.ColumnWidth = 11
.Rows.RowHeight = 12
End With

Any help would be appreciated.

Bob