I have templates that is part of a .xla workbook which are copied into a
active workbook via VBA when needed. These template only show columns A to I
and rows 1 to 75. Everything else is gray. How is this possible?

hi
not sure but check for hidden rows and columns. The author of the template
file may have hidden all but what was needed for the template.

Regards
FSt1

"Sparky13" wrote:

I have templates that is part of a .xla workbook which are copied into a
active workbook via VBA when needed. These template only show columns A to I
and rows 1 to 75. Everything else is gray. How is this possible?

Nope: Checked that first thing. Everything is blank after I75. I can insert
additional columns / rows but I get a message to save the file first to reset
the last blank cell. I work a lot with Excel but can not find anything on
this type of format.

"FSt1" wrote:

hi
not sure but check for hidden rows and columns. The author of the template
file may have hidden all but what was needed for the template.

Regards
FSt1

"Sparky13" wrote:

I have templates that is part of a .xla workbook which are copied into a
active workbook via VBA when needed. These template only show columns A to I
and rows 1 to 75. Everything else is gray. How is this possible?

hi
are column/row headers showing. can you select in the gray area.
the author may have colored the cells gray. if not then they have to be
hidden.

Regards
FSt1

"Sparky13" wrote:

Nope: Checked that first thing. Everything is blank after I75. I can insert
additional columns / rows but I get a message to save the file first to reset
the last blank cell. I work a lot with Excel but can not find anything on
this type of format.

"FSt1" wrote:

hi
not sure but check for hidden rows and columns. The author of the template
file may have hidden all but what was needed for the template.

Regards
FSt1

"Sparky13" wrote:

I have templates that is part of a .xla workbook which are copied into a
active workbook via VBA when needed. These template only show columns A to I
and rows 1 to 75. Everything else is gray. How is this possible?

Or the rows and columns height and width are set to some tiny number like .01


Gord Dibben MS Excel MVP

On Fri, 25 Jan 2008 08:42:01 -0800, FSt1 wrote:

are column/row headers showing. can you select in the gray area.
the author may have colored the cells gray. if not then they have to be
hidden.

Sorry Guys. Not hidded, Not set small, nothing in gray area to select, no
header info showing. They are just not there. I have no answer.

"Gord Dibben" wrote:

Or the rows and columns height and width are set to some tiny number like .01


Gord Dibben MS Excel MVP

On Fri, 25 Jan 2008 08:42:01 -0800, FSt1 wrote:

are column/row headers showing. can you select in the gray area.
the author may have colored the cells gray. if not then they have to be
hidden.