Hi All,

I have a problem with something I created using all the tips you guys have provided from the forum.

I have two workbooks; one for inputting quality assurance scores and one which has the scores stored. They are copied over using a simple bit of code
“Windows("Main.xls").Activate
Range("B4").Select
Selection.Copy
Windows("DataStore.xls").Activate
Range("E" & Rows.Count).End(xlUp).Offset(1).PasteSpecial Paste:=xlPasteValues”
I use this as each cell corresponds to a cell on the data store workbook, but has to be on a separate workbook due to sensitive information used in the check.
The process works 95/96% of the time but it seems randomly when checks occur instead of finding the next available row in the data store, it selects a random row and overwrites that. This has happened to 3 rows a total of 4 times (twice on row 51) out of 220 checks.
What on earth could be causing such weird and unpredictable errors?