Select only visible cells in a selected range

  • Thread starter Thread starter DataFreakFromUtah
  • Start date Start date
D

DataFreakFromUtah

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
 
Evalute should probably be evaluate or something more meaningful since no
evaluation seems to be included in the code.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to add comments to selected cells within a selected range 30
VBA set thick borders around non empty cells in range 0
Copy user selected range from all open workbooks 2
Copy to Visible Cells only;Modify Code 11
copying cells from one worksheet to another 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Select rows with visible data 0
delete selection in pivotcolumn 3

Back
Top