Non existant rows and columns

S

Sparky13

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?
 
F

FSt1

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
 
S

Sparky13

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.
 
F

FSt1

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
 
G

Gord Dibben

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


Gord Dibben MS Excel MVP
 
S

Sparky13

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.
 
G

Gord Dibben

Could you send me the workbook directly for a look-see?

Change the AT and DOT as required.


Gord
 
S

Sparky13

I would be happy to. But I am out of time today. Will revisit monday morning.
What do you mean change the AT and DOT?
 
G

Gord Dibben

MY posted email address is gorddibbATshawDOTca

Make the changes to send me the workbook as attachment.


Gord
 
D

Dave Peterson

Just to add to Gord's post...

Please don't post Gord's email address. He goes out of his way to munge his
email address so that spambots can't grab the real email address from the
newsgroups.

(A gentle reminder...)
 
Top