Removing columns (premanently).

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

Hey gang,

I have a worksheet that only uses columns A through K, and
I'd like to remove (not just hide) all remaining columns.

I've actually done this before, but my memory, as well as
help files, manuals, and web searches, are not giving up
the required procedures easily.

Any assistance in this task will be greatly appreciated.

Sean
 
Not possible, excel will always be 65536X256
I believe that hiding them and then protecting the worksheet
is the only way to go..
 
You cant remove but you can make it seem like it by
activesheet.scrollarea="a1:k100"
to reset
activesheet.scrollarea=""
 
Peo,

Thanks for the input. It was the two part -- Hide and
Protect -- procedure that simulated the permanent removal,
and made my recollection a bit sketchy.

Isolating the pertinent columns makes a very tidy
worksheet.

Thanks again,
Sean
 
[This followup was posted to microsoft.public.excel.misc and a copy was
sent to the cited author.]

I don't know how you removed columns with XL, because it has 256 columns
at any given time, no more and no less. You can simulate the effect of
having fewer columns by hiding columns and/or restricting the scroll
area, but a visual effect is the best one can achieve.

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2003
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office
 
Back
Top