Cell cursor in Excel to move or select active cell.

[ebincharles]

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.

[MarvinP]

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.

[ebincharles]

Thank you very much for your help.

However the cursor goes to all the cells. I need to move to cell where the data is been pasted.

pretty confusing...

[ebincharles]

Thank you very much Guru Marvin.. I did it.

Please Login or Register  to view this content.