Hi i've never posted here and dont know a huge amount of VB but would
appreciate any help you can give me.

I have a spread sheet set up with a userform that when the user hits
the ENTER button this macro puts the data in a worksheet.

It works fine in excel no problems. However i've noticed when the
complete workbook is open Internet Explorer the enter button gets this
error

Method 'Rows' Of Object '_Global Failed

The code behind the button is

Private Sub CommandButton3_Click()
Dim iRow As Long
Dim ws As Worksheet
Set ws = Sheet2

'find first empty row in database
iRow = ws.Cells(Rows.Count, 2) _
.End(xlUp).Offset(1, 0).Row

and debugging suggests that this is the problem =
ws.Cells(Rows.Count, 2) _

any suggestions, its not very important just strange that this is the
only macro in a workbook of hundreds that doesnt work when open in
Explorer