View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_2_] Dave Peterson[_2_] is offline
external usenet poster
 
Posts: 420
Default Macro delete columns satring row 23

You may want to rephrase your question.

Do you want rows or columns deleted?

If you really meant rows, you could use something like:

Option Explicit
Sub testme()

With ActiveSheet
.Rows("23:" & .Rows.Count).Delete
End With

End Sub


On 08/11/2010 09:24, dii jii wrote:
Hi,
Would like to get a piece of code ( excel macro) to delete Columns
starting row 23.. This is where my headers start.
I don't want include the entire column, i ahve some data above row 23.

Thanks in advance.

Jimmy


--
Dave Peterson