View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Explain some things please

Looking at the code below, what do some of these mea? Like ReDim and ReDim
Preserve? And v(i). Is this a variable, and if so, why the i in parens?

ReDim v(0 To 0)

ReDim Preserve v(0 To i)

v(i) = "State" & Right(ctrl.Name, 1)

ActiveSheet.Shapes.Range(v).Select