My group has several .xlsx files out on a network drive. Two of us execute the exact same macro on the exact same set of files -- sequentially, not concurrently -- from our respective laptops. For me, the macro runs as expected & the results are as expected. For the other person, the macro abends on a VBA statement where rowHeight is attempted to be set.
Error# = 1004
Error Description = "Unable to set the RowHeight property of the Range class."
We both have Windows 10 & we both have "Microsoft® Excel® for Microsoft 365 MSO (Version 2208 Build 16.0.15601.20526) 32-bit".
Shouldn't we both get the same results: either both succeeding or both failing with the same error? What possible reasons could there be for one of us getting a successful run & the other getting the error? This is repeatable, so it's not a case of who executes first or anything like that. We run the macro multiple times, in any order, & it still works for me, but fails for the other person. Is there some Excel option/setting that we each might have set differently that could cause this? If so, how would I determine which option(s)/setting(s) that might be?
Thanks!
Error# = 1004
Error Description = "Unable to set the RowHeight property of the Range class."
We both have Windows 10 & we both have "Microsoft® Excel® for Microsoft 365 MSO (Version 2208 Build 16.0.15601.20526) 32-bit".
Shouldn't we both get the same results: either both succeeding or both failing with the same error? What possible reasons could there be for one of us getting a successful run & the other getting the error? This is repeatable, so it's not a case of who executes first or anything like that. We run the macro multiple times, in any order, & it still works for me, but fails for the other person. Is there some Excel option/setting that we each might have set differently that could cause this? If so, how would I determine which option(s)/setting(s) that might be?
Thanks!