Given an example below.. would need to store results in a "array" .. Line 4 says "type mismatch"
Thanks.![]()
Sub arraytest() Dim myarray As Variant For i = 1 To 10 myarray(i) = i Next For i = 1 To 10 Range("B" & i).Value = myarray(i) Next End Sub
Given an example below.. would need to store results in a "array" .. Line 4 says "type mismatch"
Thanks.![]()
Sub arraytest() Dim myarray As Variant For i = 1 To 10 myarray(i) = i Next For i = 1 To 10 Range("B" & i).Value = myarray(i) Next End Sub
Last edited by vidyuthrajesh; 02-29-2012 at 04:19 PM. Reason: Yes.. it works !! Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks