Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Use of arrays | Excel Worksheet Functions | |||
Arrays | Excel Discussion (Misc queries) | |||
Begginer Help | Excel Discussion (Misc queries) | |||
VBA arrays | Excel Programming | |||
VBA for Excel Begginer | Excel Programming |