View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ninalinden@hotmail.com is offline
external usenet poster
 
Posts: 1
Default query afterrefresh not working

Feel like such an idiot.. I cannot figure out what I am doing wrong.
Keep getting runtime error "9. Run-time error '9':
Subscript out of range"

Have copy pasted the code from
http://support.microsoft.com/default...b;en-us;182735

Am working on a Swedish version of 2007, meaning sheets in the project
browser syas Blad1(Blad1) instead of sheet1(sheet1) (hope you get my
drift) Am guess this is causing a problem but not sure where to change
what.

Any ideas. It is so frustrating!!!!! especially since lots of other
poeple have gotten it to word...