Hi,
Can anyone please help me and put me right!
I am trying to select a group of shapes in Excel, copy, paste then position them using a macro. My feable attempt below selects but does not copy and paste! I haven't got as far as positioning yet.
Set myDocument =...
Has anyone tried running two Excel Workbooks together, with a macro in one replacing cell values and changing option/check boxes in the second workbook?
As soon as the first workbook effects a option/check box change in the second workbook the relevent option/check box macro click event occurs...
I am writing a series of spreadsheets for tubular joint design and am really stuck with a macro problem. I've only recently started learning VB and any helpful advice would be most welcome.
I have written a Master Excel workbook which contains common values and information to all the joints...