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
165 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

717 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