Marcro to copy range not entire column

**slohman** · 06-18-2012, 06:08 PM

Im trying to re write this macro to copy from R1 to R200 not entire column R. This what I have so far!!

Please Login or Register  to view this content.

**TMS** · 06-18-2012, 06:48 PM

I may be alone here, but I don't really understand what you are trying to do.

To copy cells R1 to R200, you could use something like:

Please Login or Register  to view this content.

Regards, TMS

**slohman** · 06-18-2012, 07:53 PM

I have a workbook with Sheets 1 (Estimate) and Sheet 2 (Order) Im trying to auto fill in Sheet 2 at when a match appears in Sheet 1, I only want it to look in R1 to R200 but it is looking at the whole column.

**TMS** · 06-18-2012, 08:16 PM

That's probably because you determine and use the last row, LR.

Just use:

Please Login or Register  to view this content.

Regards, TMS

**slohman** · 06-19-2012, 03:20 AM

Just to make this even harder what if Worksheet 1 (Estimate) was in 1 workbook and Worksheet 2 (Order) was in another can you run a macro from another workbook?