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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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…
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

747 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now