"DO Nothing"

[rspalding]

I have code where i want to add make "E12:I12" the active cells but only if it is not the active cells. I'm thinking.

If Range ("E12:I12") .Select = active, then

"Do Nothing"

else Range ("E12:I12") .Select

end if

I tried it and the "do nothing" keeps causing a compile error.

Thanks for the help.

 

[Richard Schollar]

You could do it like this:

If Selection.Address<>"$E$12:$I$12" Then Range("E12:I12").Select

 

[RoryA]

Why not just Range("E12:I12").Select?

 

[rspalding]

Richard,

I tried what you sent and it didn't get me to where my final goal was. After I save my workbook, E12:I12 is the active cell, it closes without asking to save changes. However, if I hit my print button, and then close my workbook, it askes my to save changes. The only change would be if E12:I12 was not the active cell. I'm trying to save 1 step as I'm doing this many times per day.

Robert