Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following code:
Sub HideAroundSelection() Dim intRows As Integer Dim intCols As Integer Dim rngAbove As Range Dim rngRight As Range Dim rngBelow As Range Dim rngLeft As Range intRows = Selection.Rows.Count intCols = Selection.Columns.Count 'MsgBox ("introws = " & intRows & vbLf & "intcols = " & intCols) With Selection Set rngAbove = .Cells(1, 1).Offset(-1, 0) Set rngBelow = .Cells(1, 1).Offset(intRows, 0) Set rngRight = .Cells(1, 1).Offset(0, intCols) 'Set rngLeft = .Cells(1, 1) If rngAbove.Row < 1 Then Range(rngAbove.Offset(-1, 0), .Cells(1, 1). _ Offset((1 - .Cells(1, 1).Row))).EntireRow.Hidden = True End If If rngBelow.Row < ActiveSheet.Rows.Count Then Range(rngBelow.Offset(1, 0), rngBelow.Offset _ (ActiveSheet.Rows.Count - rngBelow.Row)).EntireRow.Hidden = True End If If rngRight.Column < ActiveSheet.Columns.Count Then Range(rngRight.Offset(0, 1), rngRight. _ Offset(0, ActiveSheet.Columns.Count - rngRight.Column)).EntireColumn.Hidden = True End If 'If rngLeft.Column < 1 Then 'Range(rngLeft.Offset(0, -1), rngLeft. _ 'Offset(0, 1 - rngLeft.Column)).EntireColumn.Hidden = True 'End If End With Set rngAbove = Nothing Set rngRight = Nothing Set rngBelow = Nothing Set rngLeft = Nothing End Sub before this runs I have: Sub stopautocalc() With Application .ScreenUpdating = False .EnableEvents = False .Calculation = xlCalculationManual End With End Sub It still runs a little slow. Is there a way to speed it up? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy Visible Cells in Sheet with Merged and Hidden Cells | Excel Discussion (Misc queries) | |||
drag data vertically over hidden cells.. ignore hidden cells | Excel Discussion (Misc queries) | |||
Rows hidden by Autofilter vs hidden by changing the Hidden property | Excel Programming | |||
add cells ignoring hidden cells | Excel Worksheet Functions | |||
How do I paste hidden cells and keep them hidden? | Excel Discussion (Misc queries) |