I'm in the middle of writing a macro to do some automatic updating from excel to powerpoint. the macro is housed in excel. i need to be able to reference cell numbers which will obviously change through out the program.
i'm currently using this to populate an array A-Z
Dim aAlphabet() As String
Dim iLetter As Integer
Dim sLetter As String
Dim iElement As Integer
'Fill the array with the alphabet
For iLetter = 1 To 26
ReDim Preserve aAlphabet(iLetter)
sLetter = Chr(64 + iLetter)
aAlphabet(iLetter) = sLetter
this works fine, and i can call and loop the array to give the cells i need, however.. i also need to reference cells up to GN :) not sure about how to do this.. any tips?