Trying to Avoid Select, Selection, ActiveCell

[jwburritt]

Hello: I'm trying to avoid using the Select method, so I'm trying ActiveCell. But I've heard I should try to avoid using ActiveCell as well. Any ideas on firming up this code?

Here's what I have:

Using Select

Range(Selection.End(xlToRight), Selection.Offset(0, 7)).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Cut

Using ActiveCell

Range(ActiveCell.End(xlToRight), ActiveCell.Offset(0, 7).End(xlDown)).Cut

Thank you

 

[Joe4]

Nothing wrong with use ActiveCell, if you truly want your code to be dynamic based on where the cursor is when you call it.
It is the Select and Activate commands that you want to avoid, because that unnecessarily moves the cursor around and can slow down your code.

Assuming it works the way you need, your second code is more efficient than your first.

 

[jwburritt]

Thanks, Joe4! I was beginning to run out of ideas.