Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete a row.
Hi, if Ive assigned values from a1:a20 in vba to 'myarray', and I want
to delete the first row/value so value 2 now becomes 1 etc, what is the best way to do this. Regards Robert |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete a row.
Use code like
Rows(1).Delete or Dim MyRange As Range Set MyRange = Range("MyRange") Range("MyRange")(1, 1).EntireRow.Delete -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com wrote in message oups.com... Hi, if Ive assigned values from a1:a20 in vba to 'myarray', and I want to delete the first row/value so value 2 now becomes 1 etc, what is the best way to do this. Regards Robert |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete a row.
Sorry, didnt word that very well, I meant delete the row in the array
itself. Regards Robert |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete a row.
Sub ABC()
Dim myarray As Variant myarray = Range("MyRange").Value ' convert to a 1D array myarray = _ Application.Transpose(myarray) For i = LBound(myarray) To UBound(myarray) - 1 myarray(i) = myarray(i + 1) Next ReDim Preserve myarray(1 To UBound(myarray) - 1) For i = LBound(myarray) To UBound(myarray) Debug.Print i, myarray(i) Next End Sub -- Regards, Tom Ogilvy " wrote: Sorry, didnt word that very well, I meant delete the row in the array itself. Regards Robert |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete a row.
Sub ABC()
Dim myarray As Variant myarray = Range("MyRange").Value ' convert to a 1D array myarray = _ Application.Transpose(myarray) For i = LBound(myarray) To UBound(myarray) - 1 myarray(i) = myarray(i + 1) Next ReDim Preserve myarray(1 To UBound(myarray) - 1) For i = LBound(myarray) To UBound(myarray) Debug.Print i, myarray(i) Next End Sub -- Regards, Tom Ogilvy " wrote: Sorry, didnt word that very well, I meant delete the row in the array itself. Regards Robert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below | Excel Programming |