funkmonsteruk
IS-IT--Management
I have an excel macro which takes the selection of cells and changes their color, merges them and inserts some text.
I'm having a bit of trouble when i set the workbook to shared, i get an error message saying - Run-Time error 1004
Unable to set the merge cells property of the range class.
The merge part of the code goes:
With Selection
.mergecells = true
This only occurs when the workbook is in shared mode, which it needs to be in... Can anybody help
I'm having a bit of trouble when i set the workbook to shared, i get an error message saying - Run-Time error 1004
Unable to set the merge cells property of the range class.
The merge part of the code goes:
With Selection
.mergecells = true
This only occurs when the workbook is in shared mode, which it needs to be in... Can anybody help