Anthony's VBA Forum

[Mikey Z]

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