View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Die_Another_Day Die_Another_Day is offline
external usenet poster
 
Posts: 644
Default VB to go across and then select columns

Range(Range("BY1").End(xlToLeft).Offset(0,1),Range ("BY1")).EntireColumn.Hidden
= True

Charles

Darin Kramer wrote:
Steve,

The first column to hide is blank

So a - d will have values in, but Column E to BY will be blank. (BZ has
values in)

Appreciate your help, signing off now, but if u would lik to u can mail
me at with other questions...

Thanks!!

Darin

*** Sent via Developersdex
http://www.developersdex.com ***