Thanks again for answering.
Yes, I ment message box and not text box, you are 100% correct
So, I have now tried different solutions, including your last one, and I have found something weird.
I ended up using this:
And I noticed when I wrote only one cell in the range: E.G: Range("F2") it worked. It also did that for all the other cells when I just kept one cell in the range. But when I did "Range("F2:M2") it did not work anymore even though all the cells worked when I had them one by one in the range.
any idea why this is the case?
Bookmarks