limit

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

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

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

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

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

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

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 =...

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

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

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%?

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

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

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

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?

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

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

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

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

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

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