Share via

Excel VBA

Anonymous
2019-07-23T15:09:39+00:00

I have written a VBA code which plots a block diagram and it does that correctly on an excel sheet. I sent this worksheet with the macro to my collegue but after running it in his computer it shows like if the diagram is shifted plotted arrows in wrong positions.

My excel version is with 64 bit and my colleague version is 32 bit. I asked another colleague who has 64 bit version to run it but he had the same problem. Any advice?

Many thanks

Emad

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

2 answers

Sort by: Most helpful
  1. Anonymous
    2019-07-31T07:43:38+00:00

    I could have a look if you like, maybe it needs some use of application constants.

    BR Richard

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2019-07-23T17:16:06+00:00

    To:  Emad,

    Re:  diagram

    Could be the screen resolution is different on the colleague's machine.

    Was this answer helpful?

    0 comments No comments