ERROR: object variable or with block variable not set

[luolovepi]

When the workbook is open, I initiate the worksheet Pr as below.

Public Pr as Worksheet
set Pr = ThisWorkbook.Worksheets("Sheet1")

But I always get "object variable or with block variable not set" error here:

With Pr.ListObjects("Table1")

What is the possible reason that I get this error?

Thank you !

Sincerely,
lolo

 

[Sektor]

rorya, I have 100 times told him not to use ActiveX controls, but Forms instead. Also I told him about using programmatic name, but it seems that he just wants it to be as he wants.

 

[RoryA]

Maybe 101 times is the charm.

 

[Sektor]

May be miracle will happen?

 

[RoryA]

I can understand that once you've done a certain amount of development already on a project, it's not always feasible to start again a different way, so really my comments were more for future reference if they can't be implemented here. Though replacing public worksheet variables with code names ought to take about 10 seconds each...

@lolo,
This is meant in good humour, so please don't take offense!