hi.

i have a macro that inserts a line for the user. then the user has to go to
column AC to enter a number.

so i'd like the insert macro to end with logic that puts the cursor where it
needs to be.

i tried

Application.Goto Reference:=Worksheets("Assortment").Cells(lr, "ac")

(lr is defined as the row my cursor was on when i started the macro which
lets assume the value is 46)



it works great in that my "cursor" is on cell AC46 but its not in my view.
i can see its "selected" and sitting on AC46 in the upper left corner but
again the screen didn't move me there so the user can do what they need to do.



i tried scroll=left at the end of the sentence but it moved ac46 to the
upper left corner of my screen which is a little confusing. Its as if i
just want to scroll left or right to get the cell into view.



thanks in advance for any and all help

Tami