Using range with lastrow

How do I use range with lastrow in this case?

Please Login or Register  to view this content.

(this is what I tried, but it didn't work)

If lastrow were 26, for example, it should be Range("B25":"D25")

It worked!! Thank you =)

Why? And what could I use to replace it?

Originally Posted by joe31623

Do you need it to be in one line?

Please Login or Register  to view this content.

...but that can be combined into one line.

There are many ways to do that.

I wouldn't have to use the lastrow again because I already have a lastrow test on the top of the entire code. But it was a great help, thank you!! =)

Thank you!! I'm sure it'll help me later =)

Originally Posted by joe31623

Luuzmachado,

I'd have to see how it's being used. Occasionally, you do need .Select, but I often see it used unnecessarily.
.Select methods take up a lot of time and if it's used to .Copy/.Paste, there are better ways, namely: ws_dest.Range("A1").Cells.Value = rng_toCopy.Cells.Value.

For more information about .Select alternatives and why there are better methods, see: http://www.businessprogrammer.com/po...-using-select/

Practically speaking, it may not matter if you don't write a lot of code or if you're just moving a few things around.

*The more you know*