How to refer from a module to a specific worksheetsheet correctly?

[Falkirk]

The problem is that if I run the following code manually within the worksheet ("Orders") as a macro, it works

Please Login or Register  to view this content.

When I call it from my userform, the call itself seems to work as well, but shows this code:

Capture.PNG

Which seems to indicate it doesn't refer to the sheet correctly. I have tried with ThisWorksheet instead of aActiveWorksheet, but to no avail.

The actual error that shows is this:

Capture.PNG

Translated that means "The method Select for the class Range has failed"


Any help is greatly appreciated!

[Winon]

Hello Falkirk,

Welcome to the Forum.

Moderation removed. Code Tags are added.

[Falkirk]

Thanks I was pretty sure the PHP and HTML tags were not the right ones to use, just didn't see the #

[protonLeah]

How many workbooks are open when this macro runs?

[Falkirk]

1 workbook
5 worksheets
Start - Lists - Orders -Tips - Background

[spitfireblue]

Hi,

Your issue is that if you want to select cells you need to activate the sheet first i.e.

Please Login or Register  to view this content.

[Falkirk]

Works like a charm

[Falkirk]

Not sure if I should continue here, or make a new thread, but here goes..

The altered code now works as intended, as long as there are emty rows to delete.
when it parses this code:

Please Login or Register  to view this content.

It returns an error, if there are no blank cells to select.

My question is then: How to I test if there are empty rows within my range before I try to delete them?

[Winon]

Hello Falkirk,

One way is to try and add another line to the code;

Please Login or Register  to view this content.

Regards.

[Falkirk]

That feels a little like cheating, but I love the simplicity of the solution. Thanks alot!

[Winon]

Not really true in this case Falkirk, because what that line does is telling the code to move on if there are no Blanks in the Selection, instead of pestering you with an Error message.

You are welcome, glad I could help.

Thank you for the Rep, much appreciated!

Regards.