View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chuo Chung Seng Chuo Chung Seng is offline
external usenet poster
 
Posts: 3
Default 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