Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Non existant rows and columns
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Non existant rows and columns
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Non existant rows and columns
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Non existant rows and columns
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Non existant rows and columns
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Non existant rows and columns
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
Avoiding Errors When Attempting To Retrieve Data From A Non-existant Worksheet | Excel Worksheet Functions | |||
Formula to read non-existant reference? | Excel Worksheet Functions | |||
Can't open any files due to my non-existant virus scanner | Excel Discussion (Misc queries) |