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
|