Reply to thread

Message: <blockquote data-quote="Heretic Apostate" data-source="post: 894997" data-attributes="member: 696">I'm trying to design a spreadsheet macro so that it will go to a cell, place it in the top left corner of the screen, skip to another place on the screen, and freeze the window pane.The trouble is, sometimes the cell I'm trying to select ends up at the bottom left, sometimes the middle of the screen, but never where I want it to be.Can someone tell me of a macro command that places the selected cell at the upper left of the screen?  And one to prevent the window from moving while you move to another cell?(I may be about to take the test for Expert Excel MOUS, but that doesn't mean I know about Visual Basic. <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f641.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":(" title="Frown    :("  data-smilie="3"data-shortname=":(" /> )Edit:  Might get some answers if I post what I'm doing this for.  Here in California, there are massive budget cuts coming up.  One of the departments at the local county offices that is facing staff reductions is the accounting department of the child support services.  They need a manager, two analysts, two senior account clerks, and four account clerks to keep up with the level of work.  However, they only are allowed one of the four account clerks they have, and she is going to be graduating soon and getting a job elsewhere--and who knows how long it'll be before they can find someone who can fill her shoes?Anyway, I worked in that office for two months (before it was mutually decided that, while I'm good at accounting, they needed a clerk instead), and saw that they were doing audits of cases manually.  I won't describe the process to y'all, but basically when I got there, it would take up to eight hours to process the data on the latest system, but after I made a spreadsheet for them, it reduced the work down to less than 15 minutes, and with a lot more options as well.The trouble is, since I've learned more about Excel, I've come to see my spreadsheet as bloated and slow.  I set it up to process 1,800 lines of data, and each line of data goes through 27 calculations.  This isn't bad when you're only processing about 100 lines of data (you enter 12 lines of data at a time, each time taking about 30 seconds; then it takes 30 seconds to put in the limits and stuff), but I recently tested it with 500 lines of data, on a 733MHz Pentium III (better than the county has), and it was VERY, VERY slow.So I looked at what I knew of Excel from my latest training, and hit on using Advanced Filters.  My basic premise for the redesign was to never use formulas if I could avoid it, which means everything is on one page (so I don't have 20,000 formulas directed to the Summary, Breakouts, and Detail pages).Which is why I'm trying to set up the macros to move around the screen, and position it perfectly.  I want the relevant data easily accessible (the spreadsheet is now about 7500 rows by about 50 columns, so finding the data without macros would eat up the time I'm trying to save).It's for the children.  Plus it's for my friends in the accounting department.  I can conquer every other aspect of the spreadsheet, but I can't figure out this one little problem...</blockquote>

Verification