Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
xlCellTypeBlank Problem
I am using this code to hide rows in column A. It will not hide a cell with a
link in it even if the cell is not showing any thing in it, is there a way around this? What can be changed in the code? Private Sub Workbook_BeforePrint(Cancel As Boolean) If ActiveSheet.Name = "Production" Then Cancel = True Application.EnableEvents = False Application.ScreenUpdating = False With ActiveSheet On Error Resume Next ..Range("A6:A2000").SpecialCells(xlCellTypeBlank). EntireRow.Hidden = True .PrintOut ..Range("A6:A2000").SpecialCells(xlCellTypeBlank). EntireRow.Hidden = False On Error GoTo 0 End With Application.EnableEvents = True Application.ScreenUpdating = True End If End Sub Thank you Bob |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
xlCellTypeBlank Problem
Hi Bob
See my answer in your other thread -- Regards Ron de Bruin http://www.rondebruin.nl "Bob" wrote in message ... I am using this code to hide rows in column A. It will not hide a cell with a link in it even if the cell is not showing any thing in it, is there a way around this? What can be changed in the code? Private Sub Workbook_BeforePrint(Cancel As Boolean) If ActiveSheet.Name = "Production" Then Cancel = True Application.EnableEvents = False Application.ScreenUpdating = False With ActiveSheet On Error Resume Next .Range("A6:A2000").SpecialCells(xlCellTypeBlank).E ntireRow.Hidden = True .PrintOut .Range("A6:A2000").SpecialCells(xlCellTypeBlank).E ntireRow.Hidden = False On Error GoTo 0 End With Application.EnableEvents = True Application.ScreenUpdating = True End If End Sub Thank you Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) | |||
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming |