excel vba : how to make hidden members visible

[huiyin9218]

Hi,

I tried to copy a set of data from sheet "RawData" which was filtered and paste it at sheet c but there is something wrong in the code line "ActiveSheet.Paste", it says "cannot jump to active sheet as it is hidden". When I click excel help, it says "You specified a name that is in the type library, but it is marked as hidden. Choose Show Hidden Members on the object browser context menu to make hidden members visible."
How do I edit my code?

Sub FilterC()
Sheets("RawData").Select
    Rows("1:1").Select
    Selection.AutoFilter
    ActiveSheet.Range("$A$1:$I$1000000").AutoFilter Field:=1, Criteria1:="=c*"
    Range("A2:C2").Select
    Range(Selection, Selection.End(xlDown)).Select
    Selection.Copy
    Sheets("c").Select
    Range("A2").Select
    ActiveSheet.Paste
End Sub

Please help me.

 

[LFKim2018]

make a copy of your work and test it there.

right after
Sheets("RawData").Select
insert:

Columns.EntireColumn.Hidden = False
Rows.EntireRow.Hidden = False

HTH
</pre>

 

[huiyin9218]

make a copy of your work and test it there.

right after
Sheets("RawData").Select
insert:

Columns.EntireColumn.Hidden = False
Rows.EntireRow.Hidden = False

HTH

I copy my work on a new sheet and tried to run it. It works. Thank you

 

[LFKim2018]

I copy my work on a new sheet and tried to run it. It works. Thank you

welcome huiyin9218.. glad to help