Thread: Many columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Many columns

Darin,
You can create Views of the same WS and switch between those. e.g
Hide/show initial columns.
ViewCustom ViewsAdd.. Give it a name.
Repeat for each you require.
Then have a button or some means to switch to the next view.

NickHK

"Darin Kramer" wrote in message
...


Hi Guys,

I have data within columns a to d which is static.
From Columns e onwards to say az there is a variety of information which
needs to be entered on a row by row basis. It is rather time consuming
to write macros to hide and unhide columns depedning on the view
required. Is there any easier way of group (ie viewing) columns? (eg I
want to see columns a - d, and h - k, for purposes of data entry 1, and
then to enter data set 2, I need to see A - d and m - q), and all
others hidden).

Kind Regards

D

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