excel vba : how to make hidden members visible

huiyin9218

Board Regular
Joined
Aug 7, 2018
Messages
53
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?

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.
 
Last edited:

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

LFKim2018

Active Member
Joined
Mar 24, 2018
Messages
267
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

Board Regular
Joined
Aug 7, 2018
Messages
53
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 (y)
 

Watch MrExcel Video

Forum statistics

Threads
1,099,914
Messages
5,471,473
Members
406,764
Latest member
ExcelMaker007

This Week's Hot Topics

Top