rgr
12-11-2005, 08:56 AM
I apologize beforehand because I'm a complete idiot when it comes to VBA, but I'm trying to learn as quickly as possible.
I have a macro which will copy a dynamic range of rows and columns into another program after manipulating the columns and padding the strings. It copys all rows that have text. What I am interested in is allowing the user to selectively choose which rows will be copied with a mouse before hitting the copy macro. It may be 1 row or 20 rows. It just so happens that the table already has a column of sequential numbers in column A1:A100, which I would use as the referencing cells.
Can anyone please help me get an idea on how to do this?
Thank you
I have a macro which will copy a dynamic range of rows and columns into another program after manipulating the columns and padding the strings. It copys all rows that have text. What I am interested in is allowing the user to selectively choose which rows will be copied with a mouse before hitting the copy macro. It may be 1 row or 20 rows. It just so happens that the table already has a column of sequential numbers in column A1:A100, which I would use as the referencing cells.
Can anyone please help me get an idea on how to do this?
Thank you