cut and insert with a single line

[RSXchin]

is there a single line version of this?

Range("E:F").Cut        
Range("A:B").Insert shift:=xlToRight

 

[Glory]

Range("E:F").Cut: Range("A:B").Insert shift:=xlToRight

You will be on one line... or else!

 

[RSXchin]

Thanks so much. That'll cut down a BUNCH on some of my larger macros

 

[Glory]

I was totally screwing around. I wasn't intending to answer your question, I thought somebody would get you a unique function or combination of methods that would accomplish what you wanted.

You can do that with any statement, you know that? Adding a colon is exactly like adding a line break.

 

[wigi]

Indeed, AFAIK, this is not possible.

 

[RSXchin]

Whether or not you were joking, it still works how I needed it to. Do you know if it counts as 2 lines though? ONCE I had a problem with a module that was too big and couldn't be compiled.

Either way, I'll leave it with the colon because it makes the code look cleaner.

 

[wigi]

Do you know if it counts as 2 lines though? ONCE I had a problem with a module that was too big and couldn't be compiled.

I do not really know how it adds to the limit, but I must tell you that I never encountered a situation where I reached the limit for compilation... and I wrote big chunks of code before. The thing is... did you WRITE code, or did you RECORD code using the macro recorder? The last one has the tendency to become somewhat bigger than needed (understatement).

 

[RSXchin]

before I learned how to loop through arrays (and later how to loop through an array of arrays), my code was about 1500 lines long. Now it's only about 250.

And it can still get shorter...