Attempting not to use Worksheet.Activate

[MattyG1406]

Hello,

I have read various posts on this forum regarding not using .Activate on worksheets if possible for various reasons. Therefore I have tried to clean up one particular piece of code to adhere to this. However, I am having trouble doing so.

Here is the code in working format :

Please Login or Register  to view this content.

When I try to replace this :

Please Login or Register  to view this content.

With this :

Please Login or Register  to view this content.

I get the "Run-time error '1004' : Select method of Range class failed".

Any help, very much appreciated.

Thanks
Matt

[Ezzard]

I would suggest not using Select as well. It is almost never necessary.

[JasperD]

Please Login or Register  to view this content.

[mehmetcik]

Possibly:- you are selecting two adjacent cells and then you are looking for an empty cell below them and outside the range.

[MattyG1406]

Thanks for the advice so far, I've managed to get a little further along.

I am now getting the same error for this last section of my code :

Please Login or Register  to view this content.

[JasperD]

Why do you do all the selecting...?

Please Login or Register  to view this content.

Please click the * below if this helps

[MattyG1406]

Thanks for your help guys.

Why do you do all the selecting...?

I wish to return the cursor to the cell A1 position (i.e. CTRL & Home) on certain worksheets. Is there a way of doing this without either using .Select or .Activate, if not which is the most efficient option?

Thanks
Matt

[JasperD]

Activate is always the way to go.
My code should do what you want.