| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB to go across and then select columns
Hi there,
Situation... Data in Col a to d, and a total in column bz. I need formulae to hide cols e to by, (bz is fixed, but a - d could vary either more or less columns...) Thanks!!! Regards D *** Sent via Developersdex http://www.developersdex.com *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VB to go across and then select columns
Range("E1:BY1").EntireColumn.Hidden = True
Charles Darin Kramer wrote: Hi there, Situation... Data in Col a to d, and a total in column bz. I need formulae to hide cols e to by, (bz is fixed, but a - d could vary either more or less columns...) Thanks!!! Regards D *** Sent via Developersdex http://www.developersdex.com *** |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VB to go across and then select columns
Thanks Charles,
Unfortunately e1 is not fixed, it will always change - hence the need for some VB *** Sent via Developersdex http://www.developersdex.com *** |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VB to go across and then select columns
What is the criteria to choose Column B-E?
Charles Darin Kramer wrote: Thanks Charles, Unfortunately e1 is not fixed, it will always change - hence the need for some VB *** Sent via Developersdex http://www.developersdex.com *** |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VB to go across and then select columns
Darin,
How do you determine which column to start to hide the data in?? Is it the same for every row? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VB to go across and then select columns
Yes Steve, its the same for every row. I think using row 1 would be a
good idea... *** Sent via Developersdex http://www.developersdex.com *** |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VB to go across and then select columns
ok...then in your spreadsheet. how do you determine what column do you
want to start to hide the data at...is there something special in the first column that you want hide that will distinguish it from the data you want to show? |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VB to go across and then select columns
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 *** |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 *** |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select lowest value from 3 columns | Excel Worksheet Functions | |||
| select columns by variable | Excel Programming | |||
| Select second columns only | Excel Discussion (Misc queries) | |||
| How to select columns in loop | Excel Programming | |||
| Select from Columns | Excel Programming | |||
Linear Mode
