Dear all,
I would like to start by saying that I am a total noob.
Chemist by training, I love to play with Excel and I am just starting to learn VBA for fun.
I tried to create a Gantt chart tool, and the basic stuff (Ganntt button and macros) seems to be working ok.
However, when I try to draw connectors (connector button and macro) the code gives me the following error: runtime error 1004 : Method range of object - 'Global' failed
Could you please advise on how to solve this issue?
You can find the macros enabled file here:
drive.google.com
Thank you in advance for your help!
Best,
Silvano
I would like to start by saying that I am a total noob.
Chemist by training, I love to play with Excel and I am just starting to learn VBA for fun.
I tried to create a Gantt chart tool, and the basic stuff (Ganntt button and macros) seems to be working ok.
However, when I try to draw connectors (connector button and macro) the code gives me the following error: runtime error 1004 : Method range of object - 'Global' failed
Could you please advise on how to solve this issue?
You can find the macros enabled file here:
test_VBA_gantt4.xlsm
drive.google.com
Thank you in advance for your help!
Best,
Silvano
