View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ire.kevin@gmail.com is offline
external usenet poster
 
Posts: 4
Default 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