View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] reitanospa1@yahoo.com is offline
external usenet poster
 
Posts: 38
Default Grayed Out Columns

I have seen spreadsheets that were generated by reporting software
(payroll, I believe) that only had the number of columns that the
software was exporting - if that's the case, then they are not hidden
at all. This may be a worksheet that has been limited in width during
the export; it would still have a capacity of a standard spreadsheet,
but would require that more columns be added (as you've done). You
could write a macro that added more columns if you needed a certain
number.

Does it always stop with N? What software is generating the document?

On Jan 16, 1:52 pm, Dorci wrote:
I have a sheet that was generated by the "export" function of a VB program.
I do not have access to that program's code. My worksheet ends at column N.
There are no columns to the right, which is all grayed out. I selected the
entire sheet and chose "Unhide" to no avail. The sheet is not protected. Is
there a way to reveal the remaining columns? The one workaround I have is
inserting columns before "N" and then moving it back into place. I'm just
wondering if there's a right way to do it. Thanks in advance.