Hide

R

ranswert

I am trying to hide a range when a sheet is selected.

Private Sub Worksheet_Activate()

Dim drw As String
drw = ActiveSheet.Range("currentdraw").Value
Range(drw & "rng").Select

Selection.Hidden = True

ActiveWindow.Zoom = 85
End Sub

I get an error when this is run. What am I doing wrong?
Thanks
 
F

FSt1

hi
you can't hide a range. you can hide entire rows or entire columns but not
just protions of either or both. It a all or nothing deal.

regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

error 5
Select method of range class failed problem 2
Add value to the content of a cell with Vlookup 2
Copy filtered data to sheet 2 1
Code does not error but no copy either 4
Chart zooming 2
Advanced Filter Error - I cannot spot my Error 3
Eliminate blanks while copy row and transpose 11

Top