View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
SteveDB1 SteveDB1 is offline
external usenet poster
 
Posts: 414
Default Addendum

I want to focus on setting a list of values that will populate the myFooter()
string/array.
I'd give the rest so you could see where I wanted to go with it.


'this next next part is what I am having trouble with.
'Based on the watch's that I've set, myFooter never contains any values.
'thus my question here becomes-- how can I set a specific list of values-- from 231

'through 266 inclusive to be the values for myFooter?
'I.e., myfooter(231) has the value 231, etc.... through to myfooter(266) has
the value 266.
'As I'm specifically interested in comparing the fname1 to the value of
myfooter(i)
'for my if test.


If fname1 Like ["myFooter()"] Then


With ActiveSheet.PageSetUp
.CenterFooter = "&""Arial,Bold""&14 " & MyClmVar & SSide
End With