Excel 2007 code to sort certain cells depending on current active cell

[mpalm]

Hey All, I've been scouring around the forums and haven't been able to come up with a solid answer to this: I'm trying to sort a section of data by a date column. The section to be sorted depends on where the user is entering information. For example the user would press a button to open a form and specify what month they are entering data for. The script finds that month, adds a new line of data, and then I want it to automatically sort the data for February by date.

here's my code so far thats giving me problems, the Set Top and Set Bottom parts is where it hangs. Is there a better way to do this? (the Sorting part I got by recording a macro and changing the values to the variables i set)

Please Login or Register  to view this content.

[tigeravatar]

mpalm,

the Set Top and Set Bottom parts is where it hangs.

Please Login or Register  to view this content.

In the above quoted code is where your problems are. The issue is that Range(ActiveCell) is invalid because the Range() is unnecessary. Leave that part out, and the code will look like:

Please Login or Register  to view this content.

Make those changes and give it a try
~tigeravatar

[mpalm]

Thanks that worked for that section but now I get this error: "Method 'Range' of object '_global' failed"
on this line:

Please Login or Register  to view this content.

[tigeravatar]

mpalm,

From my above post:

Please Login or Register  to view this content.

You need to remove the Range() from the Key:=Range(Top)

~tigeravatar

[mpalm]

Ahhh balls I missed that, alright thanks i'll give that a try.
I appreciate your help!