Code to return the 2nd highest value from each tab of another workbook to current workbook

Hello! I'm extremely new to macros and codes and have only run a few successfully. I apologize for any glaring mistakes!

I'm trying to come up with a code to return the 2nd highest value from the "D" column of each tab of another workbook to my current workbook. Please see my code below. I pieced it together from other codes that I've used in the past and another code that I found online. I keep getting errors left and right when I try to alter the code. When I try to use the one below, I get a "Compile Error: Type Mismatch" popup. Can anyone help me fix this code/come up with a better one? Thank you!

Please Login or Register  to view this content.

Sorry Friend.

Welcome to the forum.

You have breached one of our forum rules and so you will get few responses.

In the meantime. Consider using the Excel "Large" Function to find the second largest value in column D.
I cannot post sample code until you edit your post to include the code tags.



Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between

Please Login or Register  to view this content.

tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)