nvm, i can't seem to understand when VBA wants me to use "=" and when not to.
nvm, i can't seem to understand when VBA wants me to use "=" and when not to.
You only need to use that when adding it as text or as part of a formula entered in to a cell, its a string to VBA so it needs the inverted comma.
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)