10-15 Worksheet

[Cassaundra Marley]

Hello. I have a spreadsheet with a column or two that I need to shuffle around. This column is largely empty from a data perspective. It does have a number of formulas and conditional formatting in place between rows 12 to 1500 but only approx. 18-19 rows with any kind of external data entered.

When I attempt to copy a column from top row to last row then "insert copied cells" in between two other columns, it can take from 0-15 minutes...you read that right folks. 10-15 minutes to complete that task. I have pulled up my Task Mgr. to watch what is happening from a hardware perspective. Before initiating this action my CPU is 8-10% and RAM sits at 650MB-700MB out of 16Gb of total ram and no meaningful programs open and actively affecting either category. Once I initiate the action I described, the CPU moves up a bit but not anywhere above 40%. The RAM usage typically goes as high as 6,500MB with the highest level at or around 10,500MB-11,600MB or around 88%-92% of available RAM. Once the task completes the RAM continues at this level for up to an additional 10-15 mins or longer to go back to the original 650MB-700MB range. Other far smaller sheets don't experience this issue and generally my computer runs cleanly. It started doing all this with this spreadsheet (probably file specific causes at play here) around 3 days ago for no apparent reason. No massive data input or additional formulas or conditional formatting added (but a small number of cells did have these attributes added during this past 3 days which is pretty much always the case as this sheet evolves). I have included a small capture of the file details but will wait to upload the entire workbook until someone lets me know they want to take a look at this issue and need the file to do so.

So before posting the actual workbook--that image doesn't really tell us much--why don't you describe the business context here? To the extent that you can do this without violating confidentiality or proprietary details, describe what the spreadsheet is all about in the first place. Such things as:

Whenever I open the VBA-Editor, or bring it back into focus, the project explorer has expanded the "Microsoft Excel objects" (mostly worksheets) and collapsed the moduls, which is exactly the opposite of what I want.

Edit: The solution provided a macro. To come close to the "default" I added it to the commandbar of the VBE, accessible with a shortcut-stroke as follows: I took the second part of the answer to mehow's question here and put it in a code module. Then I applied these instructions, to create the CommandBar entry. Then I Added the ampersand in front of the desired letter in the caption and now I can use Alt+t,t to collapse the Microsoft Excel Objects and open the rest.

So I know the most awesome MZTools ( ) has the ability to collapse all nodes in the treeview. Therefore, I searched a bit to find out how to manipulate the VBA Project treeview via Win32APIs. Most of the API calls I got from this page: (last update 1999!!).

From there it was just a matter of getting the right handles and doing the right checks. Note: The VBIDE window must be open (doesn't have to be visible) for this to work. I'd suggest perhaps creating a toolbar in the VBIDE and firing it as necessary.

It works for me in Office 2007/2010 32Bit on Windows 7, you'd have to modify the Win32APIs for 64Bit but that wouldn't be hard. You could also refine the collapsing/expanding for certain projects etc based on what you need.

This works for me in Excel 2010: In the VBA editor go to Window > Options and check the Collapse Proj. Hides Windows option. Then close all the Microsoft Excel Objects windows and collapse the Microsoft Excel Objects group in the project explorer. Save the workbook, close, and when you reopen only the modules will be open.

On page 51, in the New York City tax rate schedule, the tax rate percentages were rounded incorrectly. The Printer-friendly PDF linked on Form IT-201-I is now correct. This error did not affect the form instruction published on our website.

For the fastest processing of your refund, combine e-file with direct deposit. You can receive your New York State tax refund up to two weeks sooner than if you filed by paper and requested a paper check.

You must e-file if your software allows you to e-file your return, or if you are a tax preparer who is subject to the e-file mandate. E-file is easy, safe, and allows you to get your refund faster. Most New York taxpayers e-file.

Pay a balance due by authorizing the Tax Department to withdraw the payment from your bank account. Authorize the payment when you e-file your return or make a return payment after you file your return using our Online Services. You may also pay with a credit card.

For a complete list of credits, see also Income tax credits (search: credits). Reminder: To claim a tax credit (with the exception of the household credit and New York City school tax credit), you must complete and submit the appropriate credit form.

Protect your identity by writing only the last four digits of your Social Security number on any check or money order you send to the Tax Department. You must include your complete Social Security number on your return and payment voucher. We cannot process these forms without the complete number.

When you enter amounts on your return, enter whole dollar amounts only. This includes amounts on any credit forms, schedules, or other forms you submit with your New York State return.

If you received an income tax overpayment, including a refund, from us in 2022, you may need information from Tax Department Form 1099-G, Statement for Recipients of State Income Tax Refunds, to complete your federal return. We do not mail this form. To view and print a copy, see Get your 1099-G information online (search: 1099-G).

If you received unemployment benefits in 2022, you must report the information from Department of Labor (DOL) Form 1099-G, Statement for Recipients of Certain Government Payments, on your federal and New York State returns, if required to file.

If you were a New York State resident for only part of the year, do not file Form IT-201. If you moved into New York State on any day other than January 1, or moved out of New York State on any day other than December 31, see New York nonresidents and part-year residents.

If you were a nonresident or a part-year resident of New York State and you received income from New York sources in 2022, you must file Form IT-203, Nonresident and Part-Year Resident Income Tax Return. For more information on residency, see Am I considered a New York State resident for income tax purposes? (search: resident).

If one of you was a New York State resident and the other was a nonresident or part-year resident, you must each file a separate New York return. The resident must use Form IT-201. The nonresident or part-year resident, if required to file a New York State return, must use Form IT-203. However, if you both choose to file a joint New York State return, use Form IT-201.

Enter the correct code number and the name of your school district. This is the public school district located in the county where you were a resident on December 31, 2022. If you do not know the name of your school district, contact your nearest public school. For a detailed list of the school district names and code numbers, see School district codes (search: school district). If you are a New York City resident, look for your individual county listing.

In addition, you must make the appropriate entry at Item G if you qualify for a 90-day extension of time to file your return because your spouse died within 30 days before the due date of your return.

If you received a check from the Tax Department for the homeowner tax rebate credit, you must mark an X in the Yes box and enter the total amount you received. Do not include the amount of any STAR credit check you may have received. For more information, and to determine your amount, see Homeowner tax rebate credit (search: HTRC).

If you or your spouse (if married filing jointly) maintained or had use of an apartment or living quarters in New York City during any part of 2022 (whether or not you personally used those living quarters for any part of the year), you must mark an X in the Yes box on line E(1) and enter the number of days you were in New York City, even if on personal business, on line E(2).

Living quarters include a house, apartment, co-op, or any other dwelling that is suitable for year-round use, that you or your spouse maintain or pay for, or that is maintained for your primary use by another person, family member, or employer.

If you marked the Yes box on line E(1) and you spent 184 days or more (any part of a day is a day for this purpose) in New York City, you may be considered a resident for New York City income tax purposes. The determination of residency is based on the facts and circumstances of your own situation. See the definitions of Resident, Nonresident, and Part-year resident in these instructions. If you meet the definition, complete the New York City resident taxes and credits lines (47 through 53, 64, and 69 through 70) on Form IT-201.

New York City residents and part-year residents only: Enter in the applicable box the number of months you and your spouse (if filing a joint return) lived in New York City during 2022. We need this information to verify your New York City school tax credit.

Enter this code if you qualify for an extension of time to file and pay your tax due under the combat zone or contingency operation relief provisions. See Publication 361, New York State Income Tax Information for Military Personnel and Veterans (search: military).

Enter this code if you are filing a return on behalf of a member of the armed forces who died while serving in a combat zone. For information on filing a claim for tax forgiveness, see Publication 361.

c80f0f1006