wonderergirl
New Member
- Joined
- Aug 3, 2014
- Messages
- 28
I have this code to fixed the width of "F" Column. However, there will be a message asking me "Do You want to replace the contents of the destination cells?". I do not want to replace the contents and therefore I click "Cancel" then it will stop my whole macro from working.
This problem does not occur to all kind of data just to certain but I have no idea why it will have this error in the first place. Can anyone please help me with this and explain the reason why it can't work fine on that certain data. Thanks
This problem does not occur to all kind of data just to certain but I have no idea why it will have this error in the first place. Can anyone please help me with this and explain the reason why it can't work fine on that certain data. Thanks
Code:
Columns("F:F").Select Selection.TextToColumns Destination:=Range("F1"), DataType:=xlFixedWidth