?
Solved

How do I stop the active cell from scrolling to the top of the page when I use the delete line and insert line icon?

Posted on 2002-07-10
4
Medium Priority
?
168 Views
Last Modified: 2010-04-22
How do I stop the active cell from scrolling to the top of the page when I use the delete line and insert line icon?
0
Comment
Question by:stevelounsberry
  • 2
4 Comments
 
LVL 1

Expert Comment

by:patrickab2
ID: 7589485
The following Lotus Script called 'delrow' should do the job:

Sub delrow
     [Window 1].Activate
     [A].MoveCellPointer $Up,1
     [<<J:\lotus\work\123\tester.123>>].CreateRangeName "here",[A:B34]
     [Window 1].Activate
     [A].MoveCellPointer $Down,1
     Selection.DeleteRows $Full
     Selection.Select
     [Window 1].Activate
     [<<J:\lotus\work\123\tester.123>>].DeleteRangeName "HERE"
     [Window 1].Activate
End Sub

The file was called tester.123.

The idea is to move up a row, create a range name called 'HERE', move down a row, delete the row you originally wanted to delete with 'Selection.DeleteRows $Full' and then go to 'HERE', then last but not least delete 'HERE'. That will make sure that when you use the macro again it will go to the new 'HERE', wherever it has been created.

If you save the macro and put it on the 'Action' menu it will be available from wherever you are in the spreadsheet.

Hope this does the job.

Good luck.
0
 
LVL 1

Expert Comment

by:patrickab2
ID: 7589494
I realise it's an old query but perhaps you are still seeking a solution.
0
 
LVL 45

Expert Comment

by:patrickab
ID: 8002444
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

PAQ'd and pts removed

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

patrickab
EE Cleanup Volunteer
0
 

Accepted Solution

by:
SpideyMod earned 0 total points
ID: 8065534
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Suggested Courses
Course of the Month17 days, 10 hours left to enroll

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question