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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - error 438 on ActiveSheet.Columns(16).Hide? (https://www.excelbanter.com/excel-programming/381013-error-438-activesheet-columns-16-hide.html)

The ants are driving me crazy

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

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

Dave Peterson

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

ActiveSheet.Columns(16).Hidden = True

The ants are driving me crazy wrote:

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

--

Dave Peterson

All times are GMT +1. The time now is 06:10 PM.