Optimize code without Select

[nordicdust]

I have tried to get this code to work without the select, but I can't
This is the code that works:

Please Login or Register  to view this content.

This is one of the ways I tried without it working

Please Login or Register  to view this content.

Is there any way without select ?

[Roel Jongman]

This is code without context all the macro does is select a cell and then call another macro..

But just for the "lesson" on how to not have multiple selects

First your code, if we ignore that a With-end with is a bit pointless with one property it only has a small misstake,
it needs a point before .Range("C6")

Please Login or Register  to view this content.

The simplest code for select C6 on TilBeregning is:

Please Login or Register  to view this content.

[TMS]

Pretty sure you can't select a cell unless it is on the active sheet.

But, as that's what you're trying to avoid, you could look at Application.GoTo.

Other than that, we'd need to see more code.