Compile Error: Method or Data Member Not Found vba

Question

I am trying to automate the cleaning of a worksheet template to create a flat file for database insertion.

Below is my code that's throwing the error. I am trying to unfreeze panes for the worksheet but keep getting the Compile Error: Method or Data Member not found error on that line.

wsPerm is the worksheet I am working on.

'Unhide All Columns
wsPerm.Unprotect Password:="DRP"
wsPerm.Range("A1:FB1").EntireColumn.Hidden = False
wsPerm.FreezePanes = False
wsPerm.Activate
ActiveWindow.FreezePanes = False
wsPerm.Cells.UnMerge

Gareth · Accepted Answer · 2016-07-28 15:18:12Z

3

The .FreezePanes property only works on the Window object type so in your case, remove

wsPerm.FreezePanes = False

Which leaves:

'Unhide All Columns
wsPerm.Unprotect Password:="DRP"
wsPerm.Range("A1:FB1").EntireColumn.Hidden = False
wsPerm.Activate
ActiveWindow.FreezePanes = False
wsPerm.Cells.UnMerge

edited Jul 28, 2016 at 15:18

answered Jul 28, 2016 at 14:56

Gareth

5,2636 gold badges47 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

SanomaJean Over a year ago

Oh my gosh, I thought I tried both methods I didn't realize when I was trying ActiveWindow, I forgot to delete wsPerm.FreezePanes! thank you!!

Collectives™ on Stack Overflow

Compile Error: Method or Data Member Not Found vba

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related