error 438 on ActiveSheet.Columns(16).Hide?

  • Thread starter Thread starter The ants are driving me crazy
  • Start date Start date
T

The ants are driving me crazy

Any idea why this line would error with error 438 ("Object does not
support property or method"):

ActiveSheet.Columns(16).Hide

- I'm using Excel 2003
- There is an active sheet
- It has worked previously
- The sheet is not protected or read-only
 
ActiveSheet.Columns(16).Hidden = True
Any idea why this line would error with error 438 ("Object does not
support property or method"):

ActiveSheet.Columns(16).Hide

- I'm using Excel 2003
- There is an active sheet
- It has worked previously
- The sheet is not protected or read-only
Click to expand...
 

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

Went from Office 2003 to 2007. Error 438 VB v.6.5. 6
Enabled property failing when code tries to set it 7
Excel 2007 vs Excel 2003 = Runtime Error 438 4
get Control of a Butoon placed in the Sheet 2
Run-time error 438 1
Case select and sheet codename 7
Syntax to match sheet by codename 4
Runtime error 438 4

Back
Top