Cell cursor in Excel to move or select active cell.

Hai,

i have code to collect data from one area to another area. it contains huge data and by the below code it sorted to display in new area
based on date and number value.

it copies all data and fill in one area automatically, however the cursor in excel remains in same place while the data being copied and sorted.

I need cell cursor to move to cell every time, i mean active cell, where the data is pasted.

Please help.

Regards,
ebincharles P

Please Login or Register  to view this content.

Hi,

This will put the cursor on each cell that is changed:
Me.Cells(X1, X2).Select

Put the above line before or after your "Me.Cells(X1, X2)..." lines in your code.