macro to pan view

[fight2]

whats the command code to make the user follow where a cell went. i have a macro that moves a cell down far in the sheet, and i want the user to see its new spot.

edit:

additionally, instead of another thread ill just ask it here. what would be the command to tell if a cell has been changed by a person? i have a then statement i want to implement if any of the cells in a row is changed.

[mc84excel]

maybe...

Please Login or Register  to view this content.

change the "A1" to the cell you want to scroll to. HTH

[fight2]

ok thanks. i dont know the cell i want to scroll to. it will be rearranged somewhere else. any ideas on how i should go about this

[mc84excel]

If you dont know what cell you want to scroll to then I certainly dont!

Is it the active cell? In which case:

Please Login or Register  to view this content.

[fight2]

hahaha good response. lemme check brb

edit: ok so heres the inside scoop, i have this code:

Please Login or Register  to view this content.

which then actives this code:

Please Login or Register  to view this content.

but the user just sees the row disappear and its tough to find it cuz its a big list

[mc84excel]

This is the first I knew the cell was inside a table! That might cause problems.

I ran some tests and below seems to work

Please Login or Register  to view this content.

[mc84excel]

Did it work?

If it didn't, let me know where it's going wrong so I can look into it.

If it did, please mark this thread as SOLVED. You will find this as an option in the dropdown in Thread Tools (located in the upper right hand corner). (Optional - if I have solved your thread, you can rep me if you want by clicking on the star in the bottom left hand corner of my post)