I'm having some trouble with the below bit of code. It's the first part of trying to make sure that users don't overwrite changes in a shared sheet. The next step is to check the value of the variable against the cell it has just been entered into, to see whether another user has already typed something into that cell. If someone has, it will move down the column to the next blank cell, enter the variable into that cell, and then attempt to save again. Hacky I know, but it was the best I could come up with.
The problem is that the variable doesn't seem to be holding the value of the cell. I'm trying to get it to display into a MsgBox just so I can see if it's actually doing something. At the minute the MsgBox is blank.
Any ideas?
Bookmarks