| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I print a worksheet excluding blank rows?
I want to print a worksheet where their are blank rows for future use between
the main body of the data and the total row. I want to exclude the blank rows. How can I do this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I print a worksheet excluding blank rows?
|
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I print a worksheet excluding blank rows?
I want to automate the printing and I won't know how many blank rows I'm
going to end up with each time. "Don Guillett" wrote: hide em -- Don Guillett SalesAid Software "lohme" wrote in message ... I want to print a worksheet where their are blank rows for future use between the main body of the data and the total row. I want to exclude the blank rows. How can I do this? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I print a worksheet excluding blank rows?
You can apply a filter on a column which includes a total (or some text
like "Totals:"), selecting non-blanks. If by "automate the printing" you mean use a macro, then you can incorporate the necessary code to filter out the blanks before printing and to reset them afterwards. Hope this helps. Pete lohme wrote: I want to automate the printing and I won't know how many blank rows I'm going to end up with each time. "Don Guillett" wrote: hide em -- Don Guillett SalesAid Software "lohme" wrote in message ... I want to print a worksheet where their are blank rows for future use between the main body of the data and the total row. I want to exclude the blank rows. How can I do this? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I print a worksheet excluding blank rows?
Thanks, Don, I'll give this a try.
"Don Guillett" wrote: to hide rows with blanks in col A Sub hideem() Columns(1).SpecialCells(xlCellTypeBlanks).EntireRo w.Hidden = True End Sub -- Don Guillett SalesAid Software "lohme" wrote in message ... I want to automate the printing and I won't know how many blank rows I'm going to end up with each time. "Don Guillett" wrote: hide em -- Don Guillett SalesAid Software "lohme" wrote in message ... I want to print a worksheet where their are blank rows for future use between the main body of the data and the total row. I want to exclude the blank rows. How can I do this? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I print a worksheet excluding blank rows?
Thanks. I'll give this a try.
"Pete_UK" wrote: You can apply a filter on a column which includes a total (or some text like "Totals:"), selecting non-blanks. If by "automate the printing" you mean use a macro, then you can incorporate the necessary code to filter out the blanks before printing and to reset them afterwards. Hope this helps. Pete lohme wrote: I want to automate the printing and I won't know how many blank rows I'm going to end up with each time. "Don Guillett" wrote: hide em -- Don Guillett SalesAid Software "lohme" wrote in message ... I want to print a worksheet where their are blank rows for future use between the main body of the data and the total row. I want to exclude the blank rows. How can I do this? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I print a worksheet excluding blank rows?
That worked like a treat!!! Thanks so much.
"Don Guillett" wrote: to hide rows with blanks in col A Sub hideem() Columns(1).SpecialCells(xlCellTypeBlanks).EntireRo w.Hidden = True End Sub -- Don Guillett SalesAid Software "lohme" wrote in message ... I want to automate the printing and I won't know how many blank rows I'm going to end up with each time. "Don Guillett" wrote: hide em -- Don Guillett SalesAid Software "lohme" wrote in message ... I want to print a worksheet where their are blank rows for future use between the main body of the data and the total row. I want to exclude the blank rows. How can I do this? |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I print a worksheet excluding blank rows?
Don, what is the command to unhide the rows? unhideem?
"Don Guillett" wrote: to hide rows with blanks in col A Sub hideem() Columns(1).SpecialCells(xlCellTypeBlanks).EntireRo w.Hidden = True End Sub -- Don Guillett SalesAid Software "lohme" wrote in message ... I want to automate the printing and I won't know how many blank rows I'm going to end up with each time. "Don Guillett" wrote: hide em -- Don Guillett SalesAid Software "lohme" wrote in message ... I want to print a worksheet where their are blank rows for future use between the main body of the data and the total row. I want to exclude the blank rows. How can I do this? |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I print a worksheet excluding blank rows?
glad to help
-- Don Guillett SalesAid Software "lohme" wrote in message ... That worked like a treat!!! Thanks so much. "Don Guillett" wrote: to hide rows with blanks in col A Sub hideem() Columns(1).SpecialCells(xlCellTypeBlanks).EntireRo w.Hidden = True End Sub -- Don Guillett SalesAid Software "lohme" wrote in message ... I want to automate the printing and I won't know how many blank rows I'm going to end up with each time. "Don Guillett" wrote: hide em -- Don Guillett SalesAid Software "lohme" wrote in message ... I want to print a worksheet where their are blank rows for future use between the main body of the data and the total row. I want to exclude the blank rows. How can I do this? |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I print a worksheet excluding blank rows?
try
columns(1).rows.hidden=false -- Don Guillett SalesAid Software "lohme" wrote in message ... Don, what is the command to unhide the rows? unhideem? "Don Guillett" wrote: to hide rows with blanks in col A Sub hideem() Columns(1).SpecialCells(xlCellTypeBlanks).EntireRo w.Hidden = True End Sub -- Don Guillett SalesAid Software "lohme" wrote in message ... I want to automate the printing and I won't know how many blank rows I'm going to end up with each time. "Don Guillett" wrote: hide em -- Don Guillett SalesAid Software "lohme" wrote in message ... I want to print a worksheet where their are blank rows for future use between the main body of the data and the total row. I want to exclude the blank rows. How can I do this? |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I print a worksheet excluding blank rows?
I would suggest this (based on Don's hideem):
Sub show_em() Columns(1).SpecialCells(xlCellTypeBlanks).EntireRo w.Hidden = False End Sub Hope this helps. Pete lohme wrote: Don, what is the command to unhide the rows? unhideem? "Don Guillett" wrote: to hide rows with blanks in col A Sub hideem() Columns(1).SpecialCells(xlCellTypeBlanks).EntireRo w.Hidden = True End Sub -- Don Guillett SalesAid Software "lohme" wrote in message ... I want to automate the printing and I won't know how many blank rows I'm going to end up with each time. "Don Guillett" wrote: hide em -- Don Guillett SalesAid Software "lohme" wrote in message ... I want to print a worksheet where their are blank rows for future use between the main body of the data and the total row. I want to exclude the blank rows. How can I do this? |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I print a worksheet excluding blank rows?
Thanks - you and Don were a huge help!
"Pete_UK" wrote: I would suggest this (based on Don's hideem): Sub show_em() Columns(1).SpecialCells(xlCellTypeBlanks).EntireRo w.Hidden = False End Sub Hope this helps. Pete lohme wrote: Don, what is the command to unhide the rows? unhideem? "Don Guillett" wrote: to hide rows with blanks in col A Sub hideem() Columns(1).SpecialCells(xlCellTypeBlanks).EntireRo w.Hidden = True End Sub -- Don Guillett SalesAid Software "lohme" wrote in message ... I want to automate the printing and I won't know how many blank rows I'm going to end up with each time. "Don Guillett" wrote: hide em -- Don Guillett SalesAid Software "lohme" wrote in message ... I want to print a worksheet where their are blank rows for future use between the main body of the data and the total row. I want to exclude the blank rows. How can I do this? |
|
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I print a worksheet excluding blank rows?
glad to help
-- Don Guillett SalesAid Software "lohme" wrote in message ... Thanks - you and Don were a huge help! "Pete_UK" wrote: I would suggest this (based on Don's hideem): Sub show_em() Columns(1).SpecialCells(xlCellTypeBlanks).EntireRo w.Hidden = False End Sub Hope this helps. Pete lohme wrote: Don, what is the command to unhide the rows? unhideem? "Don Guillett" wrote: to hide rows with blanks in col A Sub hideem() Columns(1).SpecialCells(xlCellTypeBlanks).EntireRo w.Hidden = True End Sub -- Don Guillett SalesAid Software "lohme" wrote in message ... I want to automate the printing and I won't know how many blank rows I'm going to end up with each time. "Don Guillett" wrote: hide em -- Don Guillett SalesAid Software "lohme" wrote in message ... I want to print a worksheet where their are blank rows for future use between the main body of the data and the total row. I want to exclude the blank rows. How can I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Tables & not printing blank rows (revisited) | Excel Discussion (Misc queries) | |||
| Question regarding how to search a column and print a row(s) | Excel Discussion (Misc queries) | |||
| How to delete blank rows | Excel Discussion (Misc queries) | |||
| Insert rows | Excel Worksheet Functions | |||
| Copy rows of data to another worksheet where ReturnDate is blank | Excel Discussion (Misc queries) | |||
Linear Mode
