This sounds easy enough but it's giving me fits, especially since it has been working for years.

I recorded a Macro for the Acctg Dept that breaks down and sorts all the sales data and summarizes the info on separate sheets in a w-book.

99% of the time it works, sometimes it needs to be debugged.

Here's my main issue at the moment.
Keep in mind the data changes everymonth.

Using the data filter in the macro, I sort by Salesman Code, then copy the data over to his Commission sheet, then return and delete the data. That way what is ever is left is Non Commissional Sales and I can then copy that over to a separate sheet.

All has been well since recently.

I have a block of sorted data for a Salesman.
I GOTO (for simplicity sake) to A1.
I use the coding : ActiveCell.Offset(1, 0).Activate
which in the past has neatly dropped down to the first line of "visible" data, then I can C+S+E and copy it over.
Now it doesn't. It drops the cursor down to A2 rather than perhaps the first line of data which starts in A12.

What can I do to accomplish what appears like a simple move?

I'm desperate and our end of month is Dec 21.

Please help,
Mike

well.. this doesn't look like anything to do with .net, but the best way to achieve the move to the first row of availible data is: do the drop down manually saving a macro while doing it, and copy the result to your macro.. just go to the colum, press finish -> down and save that macro...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========