i am calling the following procedure in a command button_click event. its
however giving me a error. subscript out of range...

any sugestions?



textbox20.Value = Sheets("Sheet17").Range("B9").Value & Sheets
("Sheet17").Cells(Sheets("Sheet17").Range("K65535" ).End(xlUp).Row,
"K").Value
textbox21.Value = Sheets("Sheet17").Range("A9").Value & Sheets
("Sheet17").Cells(Sheets("Sheet17").Range("J65535" ).End(xlUp).Row,
"J").Value
textbox22.Value = Sheets("Sheet17").Range("C9").Value & Sheets
("Sheet17").Cells(Sheets("Sheet17").Range("L65535" ).End(xlUp).Row,
"L").Value
textbox24.Value = Sheets("Sheet17").Range("A15").Value & Sheets
("Sheet17").Cells(Sheets("Sheet17").Range("M65535" ).End(xlUp).Row,
"M").Value
Sheets("Sheet17").Cells(15, "C").Value = (Date) & " " & (Time)
Sheets("Sheet17").Cells(Sheets("Sheet17").Range("I 65535").End
(xlUp).Row, "I").Value = (Date) & " " & (Time)

' Check for the data

If textbox20.Value = "" Or textbox21.Value = "" Or textbox22.Value =
"" Or textbox24.Value = "" Then

MsgBox "Some data missing"

End If

--
Helpful advice on posting to newsgroups here...
http://www.cpearson.com/excel/newposte.htm