A begginer trying to use arrays
If you were to call me a begginner you'd be over doing it. :D
Here's what I'm trying to pull of.
I have assigned book marks, in this case A, AA, AAA, then in another
cell the user will type in the names of the bookmarks
"A, AA, AAA". From there I need to cyle threw whatever bookmarks the
user has typed in and sum up 4 numbers that are placed relative to each
bookmarked cell, and print the result from each bookmark sum in another
cell.
I'm pretty darn lost...please showme the light! Thanks.
--------------------------
Option Explicit
Sub test()
Dim i As Integer
Dim valueme() As String
valueme = Split([c60], ",")
'C60 = "A, AA, AAA" - my bookmark names
For i = 0 To UBound(valueme)
valueme(i) = Trim(valueme(i))
Next i
End Sub
|