How to get the range of filtered data? (Not formatted as table)

Mr Tojin

New Member
Joined
Dec 16, 2020
Messages
1
Office Version
  1. 365
  2. 2016
  3. 2010
Platform
  1. Windows
Hello
First of all, few disclaimer from me
Im new to here, and also relatively new to VBA although i did experiment here and there through macro recording then edit them to understand the basics
Im non english speaker, so i may lack of vocabolary when speaking english in spesific field like this
So let me first show what i want to get via picture :
Screenshot 2020-12-16 151146.png

That is from data tab, and it shows the range of filtering that is applied which our current active cell take place. So im gonna call it List Range like shown in the picture.

My documents have a lot sheets and list of data (that is not in excel table format, just usual filtered list and borders to make it as a table) some of them has this option when right-clicked, some of them not.Screenshot 2020-12-16 152436.jpg

Im now basically trying to make a macro that simulate that filtering feature.

I did found something here that is worked with table, but like i said, most of my data isnt in table.
That macro has a code that checks if activecell is in table, if it is, return the range of the table, after that there are a bunch of codes that does what i wanted to do
The problem is, i need the range of filtered data, and it return false using his code. When i tried it with range thats defined firts it works, i just need the code snippet that returns the range of filtered data

Hope im clear uttering what i mean, cheers
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Watch MrExcel Video

Forum statistics

Threads
1,127,861
Messages
5,627,314
Members
416,239
Latest member
Counselor85027

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top