Need help autofilling columns in a macro!

[radius1080]

I'm a little new to macros...but I've created a macro that sorts a bunch of data. I have it set to copy and paste data from one sheet onto a new sheet. The first two data sets I was given to sort went down 20985 rows. So when I created the macro it would set the range of copying and pasting to EX: (A2:A20985) --------And I thought I was going to be given all data that went down 20985 rows. I now realize it's all random and my next data set goes down 80,000 rows. How do I change the coding to not pick a specific range of numbers, but have it detect the number of rows it goes down and use that number. So EX: (A2-AXXXXXXX) I hope this makes sense... Any help would be appreciated =) Thank you!

[DBY]

Hello
I usually use a Variable (As Long), for example:

Please Login or Register  to view this content.

This will find the row number of the last used row in column "A". You can then use this to define the range of your copy marcro.

Hope this helps.
DBY

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[zbor]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[radius1080]

On my original macro I performed an auto-fill in a single column...So I filled in data...let's just say J2 and took it and drug down to J6956. In VBA it goes range (J2-J6956). In what way would you manipulate this to have a changing range say (J2-JXXXXX)...the "XXXXX" being the copy and pasted values down in the column next to it. So example: in one document the column next to it went down (I2-I 13000) <------[the copy and pasted values]....and (J2-J6956) needed to change to (J2-13000)....
my problem is that the autofills need to be dynamic instead to one set value. Do you have any idea how to help me in this situation?