Strange Module line
 

I have a module with the following snippet of declarations:

Public ObjectAction%, XlHwnd&, LinesSpan&
Public DB As Access.Application, UForm As UpdateDb, mdl As Access.Module
'*****
Public ws As Worksheet
Public DbPath$, CurrentCounty$


The whenever I try to do anything with the line that has the asterisks at
the end, the application locks up. I cannot add a new variable to that line,
delete any existing one, nor rename any existing one. This happens with only
this line. Any ideas?

Thank you

Strange Module line
 

Have you set a reference to Access?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

JonWayn wrote:

I have a module with the following snippet of declarations:

Public ObjectAction%, XlHwnd&, LinesSpan&
Public DB As Access.Application, UForm As UpdateDb, mdl As Access.Module
'*****
Public ws As Worksheet
Public DbPath$, CurrentCounty$


The whenever I try to do anything with the line that has the asterisks at
the end, the application locks up. I cannot add a new variable to that line,
delete any existing one, nor rename any existing one. This happens with only
this line. Any ideas?

Thank you

Strange Module line
 

In short, nope. Try Rob Bovey's code cleaner. www.appspro.com I think.

Robin Hammond.

"JonWayn" wrote in message
...
I have a module with the following snippet of declarations:

Public ObjectAction%, XlHwnd&, LinesSpan&
Public DB As Access.Application, UForm As UpdateDb, mdl As Access.Module
'*****
Public ws As Worksheet
Public DbPath$, CurrentCounty$


The whenever I try to do anything with the line that has the asterisks at
the end, the application locks up. I cannot add a new variable to that
line,
delete any existing one, nor rename any existing one. This happens with
only
this line. Any ideas?

Thank you