Search:

Type: Posts; User: mitchbvi; Keyword(s):

Page 1 of 7 1 2 3 4

Search: Search took 0.01 seconds.

  1. Add Vertical Line to an Excel chart with VBA

    First I am using Excel 2011 for Mac and all I can find on the Web seems to refer to windows versions of Excel.
    I have a cumulative frequency chart (line ) and I would like to add a vertical line/bar...
  2. Hi Andrew I have started a new thread as I...

    Hi Andrew

    I have started a new thread as I have run into a problem sorting my results and I thought that was the correct thing to do, and wanted to let you know in case you have any ideas. I have...
  3. Replies
    2
    Views
    655

    Sorting two-dimensional array

    I am using a User Form to select outputs for various cells. Then the worksheet is recalculated X times and that data stored in an array. I have had a lot of help getting this far but while I can sort...
  4. Think I may Have it

    First My thanks for staying with me on this , it has been of great help. I was having trouble as you would have guessed and I had also posted a request on another Forum. The suggestion from that was...
  5. Sorry did not explain the issue properly, I am...

    Sorry did not explain the issue properly, I am not trying to populate the User Form just collect the address's of the Out Put Cells. The main part of my code process the worksheet collecting the...
  6. Andrew First thank you for taking the time to...

    Andrew

    First thank you for taking the time to reply to my problem. My post was not from the actual routine I am running, I thought it easier to try and explain my problem with a simple user form....
  7. Using RefEdit to return multiple addresses

    I want to be able to get results from a series of out put cells on my worksheets when I run a monte carlo simulation.

    The starting point is a UserForm that has a RefEdit control. It works fine if...
  8. Quicksort still needed

    Paul

    Thank you again, I have found the percentile does not work I need to to take the min and max and build the bins smoothly between the two. I was hoping to dump the quick sort but when i do for...
  9. Percentile function Does not work with some numbers

    Paul

    This may be the wrong place to post but as I was working on the code you gave me I thought I would try. First though some clarification I wanted to calculate all the possibilities before I...
  10. Paul Thanks again this will help me streamline...

    Paul

    Thanks again this will help me streamline what I have done. I only want to run the recalculations once . The object of my exercise is to produce the data and the bins to build a histogram to...
  11. Paul Thank you, you are of course correct...

    Paul

    Thank you, you are of course correct there are a number of loops and I was trying to avoid entering data into the worksheet and the loops if possible as that slows processing down. I was...
  12. Some Variations

    Paul

    Thanks for taking the trouble to look at my problem I was rather hoping there would be a way of avoiding the loop. i have had to make a couple of alterations to your code because when I fed...
  13. Get Max and Min Values from a dynamic Array

    A model calculates a worksheet a number of times and outputs the results to an array. The array is re-dimensioned at startup based on number of calculations required. At present after calculation it...
  14. Thanks for looking folks. Turns out all iAd to do...

    Thanks for looking folks. Turns out all iAd to do was enter all the months headings in the properties of month so problem solved
  15. 12 Month Report Fails if not at least one value for each Month

    I have a report that has as its main part totals for each of 12 Months. The report is based on a cross tab query that has collated al the data it has for each line item. It works fine for years when...
  16. Access 2003 Lost Option to Export to Excel

    A routine I have used for some years annually suddenly stopped working. The code called for an export of table in Excel format. The error I got was 3170 "No installable ISAM" . when I tried to...
  17. Replies
    10
    Views
    1,329

    Hi RG When I was working through college I was...

    Hi RG

    When I was working through college I was hardwiring plug boards on IBM 601's but nothing serious since then in the programming filed. So I greatly appreciate your time in explaining to me...
  18. Replies
    10
    Views
    1,329

    Hi Rg and Jeremy Thanks so much that works...

    Hi Rg and Jeremy

    Thanks so much that works perfectly. The formula worked in a cell and as I was using it a lot I thought a custom function would be the way to go. RG, excuse a dumb question why as...
  19. Replies
    10
    Views
    1,329

    Value from custom function

    I have written a custom function that uses a combination of FV and PV . When I run it in excel it first returns a Value and when I clcik the cell again it shows the correct answer.

    This is the...
  20. Replies
    3
    Views
    1,021

    WIll try that it should work as long as I have...

    WIll try that it should work as long as I have shrink grow turned on. Seems like it should be easier than that, Thanks for you time.
  21. Replies
    3
    Views
    1,021

    Set properties of report sections using VBA

    My reports is built dynamically as the columns can change . everything seems to be working OK but I would like to be able to set the height of Headers, Footers as the report is built and I have not...
  22. Thanks Wendell Had Tried that, I od not get an...

    Thanks Wendell

    Had Tried that, I od not get an error message with the Forms!Form1!test the query opens with no data.

    I have exported the query table and form into a database and it is attached...
  23. Hi Ruirib As you can see from my previous...

    Hi Ruirib

    As you can see from my previous reply I was trying to pass the >0 from a form using you suggested syntax.

    Thanks
  24. mrjimhelps I am using Access 2003 and an...

    mrjimhelps

    I am using Access 2003 and an imbedded query. The syntax I hoped would work is =[forms]![form1]![test0] where form1 is my test form and into test0 i enter >0 or <0. The query is the...
  25. Using ">0 or

    I have a testform that has a textbox the value of which I want to pass as criteria to a field in an existing query. The text I would like to pass is ">0" or <0" but cannot get that to work.Tried...
Results 1 to 25 of 173
Page 1 of 7 1 2 3 4