Macro to skip filtered rows

Hi,

Spreadsheet as follows:

Column A - file name
Column B - email address
Colum C - file name (this is pulled from the folder when macro is run)
Column D - folder path
Column E - hyperlink created (from the macro)

Macro below:

Please Login or Register  to view this content.

I am trying to see if it is possible to add something to the macro that will skip filtered rows.

The macro draws the files from the folder and attaches it to the spreadsheet but should a file not be in the folder for one month and highlighted in the spreadsheet, it does not skip that and allocates the wrong file to the information in Column A.

Any assistance is appreciated.

Thanks!

If your selection is filtered cells then

Formula:

Please Login or Register  to view this content.

You have indicated you want to skip filtered rows.

I tested your code, it quickly creates hyperlinks to the files in a selected folder, I am not sure what the last loop is for.

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). 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.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Here is your sample back it's only 10 kb. please provide the code in the workbook and a more precise sample.

You only have one row filled out and it is not filtered. We should not have to open 4 files to figure this out.