View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JBW JBW is offline
external usenet poster
 
Posts: 42
Default runtime error (9)

I have a macro tht runs perfectly on three different machines, but whenever
we try to run it on fourth (all machines have same version of excel) it fails
and comes up with runtime error (9) subscript out of range, when you hit
debug it takes you to line in VBA (highlighted in yellow) that says
windows(macrofile).activate

can find no software version difference between machines, and all running
same operating system.

any ideas

James