?
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
?
166 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

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

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

764 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