Code presents error on shared file in teams

Hi Guys

I have a weird scenario which I cannot seem to figure out, maybe I am not seeing the problem. The code below is to copy values from multiple cells in a template to a Summary table on a different sheet in the same work work.

the excel file was created on my PC and I uploaded the file in teams for the rest of our department to work off/on. Firstly I had to set the Macro settings on every one's PC so there would not be any trust issues or disablement of macro _ Bear In Mind Not all of our team is experts in VBA, nir am for that matter....lol

Anyway this code works absolutely 100% on my PC and on one of the other team mates PC as well. But for some reason when a particuler team mate works on the file and clicks the command button I get a error from the code

the debug highlights the following issues

Sub Submit_AuditSheet_Data() and says that there is a issue with this line of code


lrow = ws_to.Cells(Rows.Count, "A").End(xlUp).Row

That is impossible as mentioned it works fine on my PC and second, the previous row is nit blank

Any idea why this is happening or is there a Options setting causing this ?


S

Please Login or Register  to view this content.

Hi AlphaFrog - If not mistaken (I did this remotely with screen share) it said something along the of Property / method that could not be executed

exactly the same as mine office 365 pro plus, what is also weird is as mentioned, a different team mate had the same problem, I teamed shared with him opened the file , selected - enable micros and trust , when into the trust center setting - enable macros - and his worked fine. I did the same with her's, but still get that error

I also closed the file on her PC and saved it back to our teams files, opened the same file on my end, and without making any changes, clicked the command button and it did what it needed to do - So there is relay nothing wrong with the code

One of my old clients had the same issue - I mailed him the file to worked from (so its not a teams issue) when he opened it same thing

Hi - any idea where I can start looking for the problem here

Thanks Ali

much appreciated