Thread: Preserve keyword
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
  
Posts: 5,934
Default Preserve keyword
You can't. If C is fixed in size, then just swap the dimensions.

--
Rick (MVP - Excel)


"LesHurley" wrote in message
...
Can anyone suggest a way to ReDimension the R dimension in
ReDim Preserve a(R,C) ?
--
Thanks for your help

Reply With QuoteReply With Quote