"Opened up" Rick code:
' To Test Function, Type some arbitrary values in range A1:E10, step through Test Code in F8 Debug Mode in VB Editor, and examine Worksheet, Immediate Window ( Ctrl+G when in VB Editor ), hover over variables in the VB Editor Window with mouse cursor, set watches on variables ( Highlight any occurrence of a variable in the VB Editor and Hit Shift+F9 ) , etc.. and then you should expected the required Output to be pasted out starting Top Left at cell M17
(_... Original Code:
' http://www.excelfox.com/forum/showth...=9658#post9658
....)
Required Function_...Code:' To Test Function, Type some arbitrary values in range A1:E10, step through Test Code in F8 Debug Mode in VB Editor, and examine Worksheet, Immediate Window ( Ctrl+G when in VB Editor ), hover over variables in the VB Editor Window with mouse cursor, set watches on variables ( Highlight any occurrence of a variable in the VB Editor and Hit Shift+F9 ) , etc.. and then you should expected the required Output to be pasted out starting Top Left at cell M17 ' http://www.excelfox.com/forum/showthread.php/2083-Delete-One-Row-From-A-2D-Variant-Array?p=9658#post9658 Sub Rick() Dim sp() As Variant Dim DataArr() As Variant: Let DataArr() = Range("A1:E10").Value Let sp() = Fu_Rick(DataArr(), 5) Range("M17").Resize(UBound(sp(), 1), UBound(sp(), 2)).ClearContents Let Range("M17").Resize(UBound(sp(), 1), UBound(sp(), 2)) = sp() End Sub
Function Fu_Rick(ByRef arrIn() As Variant, ByVal RowToDelete As Long) As Variant
_... in next Post




Reply With Quote
Bookmarks