VBA to recognize active cell and total rows

[just_some_dude]

What I'd like is, the macro will apply to the cell to the right of whatever my active cell is. For example, the column may not be B, it may be H, or I. Also, only copy down as far as the there are filled cells in the rows. So, one sheet there may be 10 rows, another there may be 200 rows.

Is there a way to adjust this macro to do that?

Thanks.

Please Login or Register  to view this content.

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[just_some_dude]

I've attached the sheet. Does this help?

[just_some_dude]

Anyone have the opportunity to check this out? Thanks.

[just_some_dude]

I've been messing a bit more with it. You can see where I'm stuck...

Please Login or Register  to view this content.

[Xrull]

Just_some_dude,

It is a bit difficult for me to work with moving tagets, but maybe someone can improve on this.

Place this macro in a module, and see if it works for the sheet named "Try the Macro here"

Please Login or Register  to view this content.

Regards,
Xrull

[just_some_dude]

Well, how about this... Is there any way to autofill down to the last row, but only specific to the selection made? For example, I've gotten to the point where it selects the three cells I need to copy down, but now I need to autofill to the last row. I don't what to specify which columns are going to be copied down, just the selection made.

[Xrull]

Just_some_dude,
Try this:

Please Login or Register  to view this content.

Regards,
Xrull

[Xrull]

Just_some_dude,
I think this code will process to the last cell selected:

Please Login or Register  to view this content.

Regards,
Xrull

[just_some_dude]

Thanks a lot Xrull. That's pretty much what I needed. I made a few changes and need to figure out a few things. Now, when I run this macro it adds one extra cell to the bottom of the list. Basically, it goes one row beyond the last row.

Please Login or Register  to view this content.

[Xrull]

Just_some_dude,
Try this one:

Please Login or Register  to view this content.

This one is better because you don't have to select the cells:

Please Login or Register  to view this content.

Regards,
Xrull