Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select only visible cells in a selected range
No question here, just a procedure for the archive.
Search critera: Select only visible cells in a selected range manually select just the visible cells in a subset of the whole page Prompt target to select specific specifically range and only visible cells Sub SelectOnlyVisibleCellsInSelectedRange() 'Selects only the visible cells in a selected range. On Error Resume Next Dim MyRange As Range Set MyRange = Application.InputBox( _ prompt:="Select Range of Cells to Evalute", Type:=8) MyRange.SpecialCells(xlCellTypeVisible).Select End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select only visible cells in a selected range
Evalute should probably be evaluate or something more meaningful since no
evaluation seems to be included in the code. -- Regards, Tom Ogilvy "DataFreakFromUtah" wrote in message om... No question here, just a procedure for the archive. Search critera: Select only visible cells in a selected range manually select just the visible cells in a subset of the whole page Prompt target to select specific specifically range and only visible cells Sub SelectOnlyVisibleCellsInSelectedRange() 'Selects only the visible cells in a selected range. On Error Resume Next Dim MyRange As Range Set MyRange = Application.InputBox( _ prompt:="Select Range of Cells to Evalute", Type:=8) MyRange.SpecialCells(xlCellTypeVisible).Select End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making selected cells more visible | Excel Discussion (Misc queries) | |||
Selected cells not visible | Excel Discussion (Misc queries) | |||
contents in cells are not visible when word wrap is selected | Excel Discussion (Misc queries) | |||
Select Visible Cells Only | Excel Discussion (Misc queries) | |||
Trying to select the visible range of cells | Excel Programming |