Macro for automation of a sort column, Code nearly complete.

[donnydorko]

Please Login or Register  to view this content.

This is what i have so far, but basically i have a file which I sort through various headers, so i have a default sort column in V so i can return to the original state any time i want. I normally go through the process of putting a 1 in cell 1, column v, then a 2 , and 3 after. highlight all 3 cells and move down the file so i have a default sort column. The problem is the files are various sizes ranging from 2000 rows to even more. Is there a way I can have a macro put a 1 , 2 , 3 and drag down untill the last cell of data? this is the part i couldnt figure out. I want it dynamic in other words, currently i have to enter the row number for it to count to. I have to do this many times because i delete rows, add data, so i have to redo the default counter so i dont lose any of the data's placements when i sort again.

Thanks



THanks

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

You also need to be more careful with the wording of your Thread Titles

[donnydorko]

sorry about that, hopefully this clears things up , added the tags as required.

[VBA Noob]

This assumes col U has the last data in. Change to suit

Please Login or Register  to view this content.

VBA Noob

[donnydorko]

Says run time error 1004,

autofill method of Range class failed.

Please Login or Register  to view this content.

[VBA Noob]

I also get that message if nothing in Col U.

Did you see my note.

This assumes col U has the last data in. Change to suit

Change the Col U to a column you know as data

VBA Noob

[donnydorko]

Perfect, thanks again man.

Probably simple requests, but this makes a world of difference, i love this forum!