Hi, i'm not too familiar with VBA in Excel, but i'll try my best.

I'm trying to run a macro that'll generate numbers and fit it into
Access DB (which i've created using another macro)

the loop seems to be running fine, but an error occurs saying: "Either
BOF or EOF is TRUE, or the current record has been deleted. Requested
operation requires a current record."
and points towards this line: "

-- Recordset1.Update <--
Recordset1.Close
Set Recordset1 = Nothing


--
silvest
------------------------------------------------------------------------
silvest's Profile: http://www.excelforum.com/member.php...o&userid=14662
View this thread: http://www.excelforum.com/showthread...hreadid=275742