Keep getting Block without end if error. Please help!!

Hi All,

I combined two marco codes i found online into one but keep getting the "Block without end if error".

Could someone kindly please go through the code below to spot any errors, and help to rectify it please? Your help is deeply appreciated! Been stuck on this for days.

Please Login or Register  to view this content.

Thank you!!

You've got an End If and a Nex missing.

Try this.

Please Login or Register  to view this content.

PS Can you please add code tags when posting code?

Originally Posted by Norie

You've got an End If and a Nex missing.

Try this.

Please Login or Register  to view this content.

PS Can you please add code tags when posting code?

Apologies, i'm not sure what code tags. I will refer to your "If posting code please use code tags, see here." to try to understand.

Thanks for your edit, however i am not getting a "file not found error" for 'Kill TempFilePath & TempFileName & FileExtStr

would it be helpful if i post the two originally seperate codes which I am trying to merge?

1) First code

Please Login or Register  to view this content.

2) Second code

Please Login or Register  to view this content.

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

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] 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)