• Status: Solved
  • Priority: High
  • Security: Public
  • Views: 68
  • Last Modified:

Hide columns 4n RP

hide columns from CB to CH

call RPW
4n_a1.PNG

file here
n4_9876543.xlsm
0
ADRIANA P
Asked:
ADRIANA P
  • 2
  • 2
1 Solution
 
Ryan ChongCommented:
try:

Sub RPW()
    Range("CB:CH").EntireColumn.Hidden = True
End Sub

Open in new window

1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Ryan  Thanks for the fast reponse

if i want to just hide one column
example CB only what have to do or change in the code ??
0
 
Ryan ChongCommented:
if i want to just hide one column

example CB only what have to do or change in the code ??

sure, then try this instead:

Range("CB:CB").EntireColumn.Hidden = True

Open in new window

1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Great Job  best expert!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now