Thread: Sort problem
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
 
Posts: 913
Default Sort problem

On Mon, 14 Apr 2008 13:04:01 -0700, Karen53
wrote:

Hi,

wbkNew is a global variable already set in another procedure. This value is
correct according to the debug.print statements.


Maybe you have a leading or trailing space in the ShName, not seen in
you Debug printout, that makes the wkbNew(ShName) give a "subscript
out of range".

Lars-Åke