View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chinny chinny is offline
external usenet poster
 
Posts: 9
Default Columns AV:BE Showing (Not Suppose To)

Morning Guys,

The script below hides selected columns however columns AV:BE are hiding but
they are also including column AU and BF. Columns AU and BF are not supposed
to hide. Please see below.

If Range("B44") = Range("BD15") Then
Range("E:L,N:W, AB:AD,AK:AR,AV:BE").Select
Selection.EntireColumn.Hidden = True
Range("A45").Value = "After Hours Working"
Else

Would there be a problems in the script above?

Cheers