[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
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
?
167 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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…
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
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

649 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