Run-time error '91'

A

ajayb

Hi,

I have an Excel workbook that works fine when opening in an Excel window.
This workbook needs to sit on our intranet though. When opening it opens in
an Internet Explorer Window. The file works ok except that the following
code which is attached to a button on a form:

Private Sub FelipeButton32_Click()
ActiveSheet.PageSetup.PrintArea = "$AA$13:$Ad$16"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, collate:=True
ActiveSheet.PageSetup.PrintArea = "$B$2:$k$175"
End Sub

Causes:
Run-Time error '91' - Object variable or With block variable not set.

Yet the routine doesn't cause the problem when opened in Excel normally.
Can anyone tell me why at all?

Thanks

Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Object variable error 0
If Cells.Find returns run-time error '91': Object variableor With block variable not set 1
Print two different areas on a worksheet 5
VBA ERROR 2
Run Time Error 91 15
Run time error '91' 2
VBA ERROR 2
Run-time error 91 Object variable [2003] 2

Top