automatically selecting only specific visible cells in a filtered range

**catchnanan** · 07-20-2018, 12:59 PM

Hai guys

I am having a filtered range say a3:a30
after filtering my cells will look like below
A B
a5 1
a8. 4
a9 3
a20 2
a24 1
a25 1

what i want is when i click/select a cell in the filtered column A,on the basis of value in colomn B
the number of cells below the selected cell including the active cell should get selected.

Example when i click a8 cell,a8,a9,a20,a24 have to be selected,here four cells are selected bcoz the corresponding value in b8 cell is 4.

when i use the method below

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
if target .column= 2 then
activecell.select
Range(selection,selection.cells(activecells.offset(0,1).value,0).specialcells(XlcellTypeVisible).select
end if
Exit sub

Please Login or Register  to view this content.

it selects invisible cells also a8,a9,a10,a11
Can any one help to solve this issue

**jaslake** · 07-20-2018, 03:19 PM

Hi catchnanan

Please attach a sample workbook the Structure of which is the same as your actual workbook.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

INCLUDE ANY CODE YOU'RE USING OR HAVE TRIED.

Remember to desensitize the data.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.