Posts by CapG

There is no target cell per say. Because this in the middle of execution the control shifts from primary code to template code.

Primary code here is a loop having to split one workbook to multiple workbooks and

each workbook should have incorporated change event macro in it. The template file is used for this purpose.

below is the primary code, after the line highlighted in yellow executes, the control transfers to template cod

Quote from CapG

this code is in a template file so the new workbooks that are created(in a loop) goes through this template file to incorporate event handler in every workbook that it undergoes. It didnt occur for other workbook though. Do I have to convert r to range in global declaration?

This is what it looks like while stepping into the template code:

First these two lines were stepped into without error

worksheetChange sub exists since Target.countlarge>1 next the control goes to selectionChange sub. See below screenshot where the overflow error occurs when I hover over r it displays=> r=Empty

Sure I will get back to you

Understood, I will look into it.

Thanks!

I also used the same code to overcome the error, it worked. Thanks Roy for your help.

But out of curiosity just wanted to know why did that overflow error occurred only for one file

Quote from CapG

this code is in a template file so the new workbooks that are created(in a loop) goes through this template file to incorporate event handler in every workbook that it undergoes. It didnt occur for other workbook though. Do I have to convert r to range in global declaration?

Like I said the error appears only for one file out of 40 files.

Yes I agree r cannot be range.

I tried setting r=target.value(r declared as variant globally) it throws same error saying "Overflow".

BUT i havent tried declaring r as string explicitly as I thought variant would implicitly convert to particular datatype.

To my understanding the purpose of r in selection change event is to- when cell value in in range BM-BO is deleted the deletion should reflect in the corresponding row having that header(BM-BO has a data validation list).

Now when I have used SET r= target this functionality is not working.

Thanks Carim SET seemingly worked! I need to understand and restructure the code.

this code is in a template file so the new workbooks that are created(in a loop) goes through this template file to incorporate event handler in every workbook that it undergoes. It didnt occur for other workbook though. Do I have to convert r to range in global declaration?

But could you tell what is the cause of overflow error message?

I am really not sure about this codes as I didnt write this. I assume r is used here in this section to delete the corresponding cells when delete key is pressed from range BM to BO

getting error for the line

That worked like a charm with fewer steps!

Thankyou

Here is the script(.vbs) that I' trying to execute to run macro in a specific workbook and I have checked enable macro option in trusted setting. Though I'm getting above error message

OK.

Thanks for your quick response. Appreciate it!

Yes every time I try to navigate to the url to hit download, it asks for login credentials. There are around 5k records I need to iterate to download files

From this website called mouse flow.

How do I tackle with entering login credentials every time. I cannot get past without entering credentials

The reason might be that, every time I open the url it ask for credentials to login.