Dear Group,
I have an error in htmlmaker when trying to use this program. I'm using Excel 2000, but not Outlook. I loaded the missing Outlook library 9.0.
Compile error: Can't find Project or Library
Left is highlighted.
reInput:
On Error Resume Next
Set rngSelection = Application.InputBox(strMsg1, Left(strMsg2, 46), Selection.Address, Type:=8)
If rngSelection Is Nothing Then Exit Sub
Err.Clear
On Error GoTo 0
On Error GoTo Errline
If rngSelection.Rows.Count > 30 Or rngSelection.Columns.Count > 26 Or rngSelection.Rows.Count = Rows.Count Then
Select Case MsgBox(strMsg2, vbQuestion + vbYesNoCancel)
Case vbNo: GoTo reInput
Case vbCancel: Exit Sub
End Select
End If
End If
Can you assist?
Thanks,
Jodi
I have an error in htmlmaker when trying to use this program. I'm using Excel 2000, but not Outlook. I loaded the missing Outlook library 9.0.
Compile error: Can't find Project or Library
Left is highlighted.
reInput:
On Error Resume Next
Set rngSelection = Application.InputBox(strMsg1, Left(strMsg2, 46), Selection.Address, Type:=8)
If rngSelection Is Nothing Then Exit Sub
Err.Clear
On Error GoTo 0
On Error GoTo Errline
If rngSelection.Rows.Count > 30 Or rngSelection.Columns.Count > 26 Or rngSelection.Rows.Count = Rows.Count Then
Select Case MsgBox(strMsg2, vbQuestion + vbYesNoCancel)
Case vbNo: GoTo reInput
Case vbCancel: Exit Sub
End Select
End If
End If
Can you assist?
Thanks,
Jodi