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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Non existant rows and columns
Could you send me the workbook directly for a look-see?
Change the AT and DOT as required. Gord On Fri, 25 Jan 2008 11:36:00 -0800, Sparky13 wrote: 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. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Non existant rows and columns
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? "Gord Dibben" wrote: Could you send me the workbook directly for a look-see? Change the AT and DOT as required. Gord On Fri, 25 Jan 2008 11:36:00 -0800, Sparky13 wrote: 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. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Non existant rows and columns
MY posted email address is gorddibbATshawDOTca
Make the changes to send me the workbook as attachment. Gord On Fri, 25 Jan 2008 12:20:01 -0800, Sparky13 wrote: 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? "Gord Dibben" wrote: Could you send me the workbook directly for a look-see? Change the AT and DOT as required. Gord On Fri, 25 Jan 2008 11:36:00 -0800, Sparky13 wrote: 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. |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Non existant rows and columns
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...) Gord Dibben wrote: MY posted email address is gorddibbATshawDOTca Make the changes to send me the workbook as attachment. Gord On Fri, 25 Jan 2008 12:20:01 -0800, Sparky13 wrote: 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? "Gord Dibben" wrote: Could you send me the workbook directly for a look-see? Change the AT and DOT as required. Gord On Fri, 25 Jan 2008 11:36:00 -0800, Sparky13 wrote: 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. -- Dave Peterson |
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) |