Macro doesn't work for me, but works for others

[craigo298er]

I had this macro made and it works for at least 6 other people that I've seen run it successfully. When I use the same file, on the same network, with the same security settings, with the required password entered correctly...it doesn't work and gives me errors. I have other macros that pull data from the same databases successfully. Why am I unable to run it

 

[dmt32]

Hi,
its more helpful to forum if you post all your code using code tags (menu bar > VBA)

Just a guess but see if replacing the highlighted line with following & see if resolves

 Set endcol = ws.Cells(1, ws.Cells(1, ws.Columns.Count).End(xlToLeft).Column)

If not, then post all your code - plenty here to assist you

Dave