Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Marco Reverse Variant and paste into other sheet
Hi All,
I have some error occur during reversing an Variant. The Avalue(i) = StrReverse(Avalue(i)) having error mention that "Subscript out of range" Anyone can advise an solution to me pls..... Dim Avalue() As Variant Sheets("Sheet1").Select Avalue = Range("B3:B500").Value For i = LBound(Avalue) To UBound(Avalue) Avalue(i) = StrReverse(Avalue(i)) Next i Sheets("Sheet2").Select Range("B3:B500") = Avalue End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Marco button, Copy and paste depending on criteria | Excel Programming | |||
Marco to copy and paste column as well as edit link | Excel Programming | |||
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
reverse cut and paste | Excel Worksheet Functions | |||
Best way to paste a variant array into a range? | Excel Programming |