limit

  1. G

    Conditional Drawdown

    Hi I want to calculate drawdown so that I am in a position to ascertain if the following statements are correct: SPX For the period 1900 – 2010, 5% corrections occurred three times per year on average, 10% corrections occurred once per year on average, and 20% corrections occurred once every...
  2. gyro2222

    Limit Excel file access to a certain number of times

    I have an excel file which imports data from a text file and then generates a report based on the data. I would like to have a way to limit the number of times a user can access this report, so I can charge for usage. Ideally, i could set the number of times they can run this file (or import...
  3. A

    Character Count Limit

    Hi everyone, first post... Need help. I need to set a specific character count in an excel cell. I only have 5 lines, first line is a count of 50 characters (including spaces) and the rest are a count of 75. If it can't be done, Word is an option. Really need to get this done asap, any help is...
  4. M

    Fill Blank Cells with Formula From Row Above

    Where I work, Excel 2007 is still being used. When doing autofill on workbooks with thousands of rows, you get an error stating "Selection is too large" because of the 8192 different areas in the special cells range issue. I found code online (by Dave Peterson by way of Ron De Bruin) that will...
  5. M

    Save "limit iterations"

    Hi all, I have an Excel sheet that I send to customers that has one intended circular reference. This is no issue when I check "limit iterations" box and set it to 1. However this setting is not saved to the workbook and each time a customer opens the workbook he/she gets the circular reference...
  6. N

    SQL for Oracle RDB - SELECT TOP 1000 ROWS??

    Hello, I am trying to import an Oracle RDB Recordset to Excel via Microsoft VBA. I currently have a working SQL string but would like to return just the top 1000 rows. Normally I would use "SELECT TOP 1000" for an SQL Server. I understand that this will not work for Oracle, so I tried Oracles...
  7. T

    Running A Macro for Specific Rows Only

    Hi, I'm sure this is really simple but I can't figure it out for the life of me. I have the following Macro: Sub UnhideRow1() Dim i As Long If columns("A").SpecialCells(xlCellTypeVisible).Count = rows.Count Then Exit Sub i = 1 Do Until rows(i).Hidden = True i = i + 1 Loop rows(i).Hidden =...
  8. E

    Nesting IF's Limit

    Dear Forum, I am categorizing my different business units based on net sales. I have set different criterias depending on the business unit name and 3 sale intervalls. Now I get an error that I cannot add another IF function for my last business unit. So, my question is if I somehow can shorten...
  9. D

    Looping limitation - Help on Copying Rows to New File

    Hello - I have a database that needs breaking down in order to fulfill a request. I've been trying to create a macro to copy one row to a new workbook (starting from row 3), file name save as a value of the cell (C1), and move onto the next row. However, my code appears to only loop through...
  10. J

    How To Limit the Sum of Numbers to 100

    Hello, How do I limit the sum of numbers to 100%? For example, in productivity, one person may put more productive hours than the required number of hours, naturally, the productivity is more than 100%. How can I put a limit of 100%?
  11. J

    Only part of a sheet embed in Word (not whole workbook)

    When I select a portion of a sheet and embed (or link) into a word doc it works fine. But when the Word user begins to work in the embedded object the entire workbook is visible. I don't want the Word user to see beyond the range I embedded. How can I have only a portion of a workbook available...
  12. S

    How to set mulplication of cells upto a limit

    Sorry if title is inaccurate I did not know how to describe it. What I mean is how do you make it so say for example you get paid £5 for every sale until 5 sales then each sale is worth £8 until 8 sales where they all become worth £10 each. For example: 1 sale = £5 4 sales therefore = £20 BUT 5...
  13. K

    Why does my string snap?

    Hello, I have written the following function in VBA, which converts a 1-dimensional data array into a text string by concatenating successive data points separated by a comma. The string is defined as variable length with no fixed limit, and I had understood this should allow for about 2...
  14. M

    disable a comman button after one click then

    enable it again 28 days later? Is this possible? I have a command button that copy and pastes data but this information only needs to be done every month. Any help with the VBA code?
  15. P

    a function that can see the max amount for deductible and stop when it rich maximum amount limit.

    My Best Regards !!! I am having a hard time with my sheet, I will try to explain it clearly, I have a price in one cell and other prices in another cell but in different column (the reason is, because the prices are a different category) let see :- in G7 I put a price for consultation 75 $ in...
  16. R

    String limit for Range.FormulaArray property

    I have some vba code that places a UDF formula on a particular Range's FormulaArray property. Problem is the formula length can sometimes exceed 255 chars causing the code to fail. I posted this question at the MSDN forums here...
  17. M

    VBA Macro: Paste Excel Cells to PPT Slides, paste limit?!

    Hello everyone, I have Microsoft Office 2003 and Windows Vista. I'm a relative VBA newbie, but I have been experimenting with copying individual cells in Excel to individual PowerPoint slides via a macro. No matter how many individual cells I copy to individual slides, and no matter what order...
  18. S

    Data Table Excel 2007

    Hi, I have a quick question in Excel 2007. I am setting a huge workbook in a manual calculation state. Then I am creating a big Data Table with 80,000 rows. It seems like it takes forever to only create the Data Table... If I press ESC, the table seems all fine. Does 80,000 rows exceeds...
  19. J

    Character Restriction Limit on VBA

    Hi. I am using VBA on Microsoft Excel, and have created a userform containing several text boxes. On one of these text boxes, I am trying to implement a character limit, restricting users from entering more characters than a specified limit (In my case, the limit needs to be 8 characters). I've...
  20. savindrasingh

    Increase limit of For loop during execution

    Hello Experts, Can any one please let me know how to increase the limit of FOR NEXT LOOP upper limit during execution of the loop? For example: If I am trying to execute a piece of code on list of items in a column and the number of items in the column are increased during execution based...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top