LinkBack URL
About LinkBacks
asac 
Just a brief question:
At [ If r.Offset(0, -1).Value <> r.Value Then ' Change this offset to match the one below] It gives the ‘Run-time error ‘13’: Type mismatch’ is it my offset value that causes the error? Thanks again.
Just a brief question:
At [ If r.Offset(0, -1).Value <> r.Value Then ' Change this offset to match the one below] It gives the ‘Run-time error ‘13’: Type mismatch’ is it my offset value that causes the error? Thanks again.
Im not in front of my computer today but the offset value is not the problem i doubt think. You could try deleting the value in that column that keeps track of the last value entered.. that would be column AF if you're using my exact offsets... and see if you still get the error. I can't do much today but probably tomorrow morning? What value are you entering when this happens?
I realized that I might have a conflict at the cell where the formula is. It will only run the code as long as I keep my cursor on the same row. Otherwise it won't record. I wonder if I need to add a sub code involving the cursor location so that when any cell changes the cursor goes to the cell row to fire the code?
Last edited by asac; 12-14-2020 at 05:35 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks