Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    1
    Views
    33

    over flow error

    I have this code that encounters an error as a result of trying to divide by zero. How can I avoid this error?


    Range("P2") / WorksheetFunction.Subtotal(9, Range("U18:U18" & Range("U" &...
  2. Replies
    2
    Views
    68

    Re: Check file exist vba

    Works Great!! Thank you AlphaFrog
  3. Replies
    2
    Views
    68

    Check file exist vba

    I'm using MKDir to create a file in a folder. When creating a file, the file name is saved with a random generated 16-digits Alpha-Numeric (i.e. DS1O-Q7LN-X7MP-EJA8) name. The code below checks for...
  4. Replies
    12
    Views
    199

    Re: Dynamic Decimal Placement

    After deciphering what the code was doing, I figure it out how to merge your code with the original code. I reserched what Rept function does and this is what I put together. The red highlighted...
  5. Replies
    12
    Views
    199

    Re: Dynamic Decimal Placement

    Correct...this is the output I'm looking for. Now the challenge is to implement it into the original code
  6. Replies
    12
    Views
    199

    Re: Dynamic Decimal Placement

    when I type in a value (ex 1),

    If the textbox variable is 2, the output should be $1.00
    If the textbox variable is 3, the output should be $1.000
  7. Replies
    12
    Views
    199

    Re: Dynamic Decimal Placement

    Runtime error 6...Overflow

    Output shows $1,000,000,000,000,000.000
  8. Replies
    12
    Views
    199

    Re: Dynamic Decimal Placement

    Still seeking help for this problems. Thank you kindly
  9. Replies
    11
    Views
    211

    Re: edit textfile error

    I found my problem accidentally when I discover my Dim variables were place at the top of all the code instead of placing them in each of the Workbook Open event and in the Workbook Closed Event. ...
  10. Replies
    12
    Views
    199

    Re: Dynamic Decimal Placement

    How do I adjust the codes in red. I have to manually change the numbers in red from 2 zeros to 3 zeros so that it does not cause an error.


    CCur(v) / 100
  11. Replies
    12
    Views
    199

    Dynamic Decimal Placement

    I using this code that formats the number as I type. I would like to make more dynamic to be able to choose the format base on a variable enter in another textbox. Currently the format is hard...
  12. Replies
    11
    Views
    211

    Re: edit textfile error

    Is it still possible to get an answer to my problem. Really appreciate the help.
  13. Replies
    11
    Views
    211

    Re: edit textfile error

    I will... Thank you for understanding.
  14. Replies
    11
    Views
    211

    Re: edit textfile error

    My apologies Fluff. I'm at my witts end trying to fix this problem. So I thought I would get extra help . Please except my apologies.
  15. Replies
    11
    Views
    211

    Re: edit textfile error

    When I open the workbook, the code edits the second line in the file

    43678.3604398148
    43691.4901387963

    however, when I close the workbook and check the text file, this is the output.

    ...
  16. Replies
    11
    Views
    211

    Re: edit textfile error

    When I first start my workbook for the very first time, it records two times.

    Start time
    Current Time

    The Start Time should never be change, however, I want to record the the Current Time when...
  17. Replies
    11
    Views
    211

    edit textfile error

    I have this code in my workbook open and workbook close events. When the workbook opens, the code is to edit the second entry (which it does exactly what it is suppose to do), however, when I close...
  18. Replies
    3
    Views
    27

    Re: find function

    Works great thank you dmt32! Cheers!
  19. Replies
    3
    Views
    27

    find function

    I'm trying to limit the range using Columns("A18:A" & LRow) , however i'm getting an error. The below code works fine, however I'm wondering is it not possible to limit the range from a specific...
  20. Replies
    1
    Views
    98

    Re: Edit textfile vba

    I want to update the time only, which is on the second line in the text file


    Open OPath & OFile For Output As #1
    Print #1 , Date; vbNewLine; Time; vbNewLine ;tbName; vbNewLine; tbDepNm;...
  21. Replies
    1
    Views
    98

    Edit textfile vba

    I have this code that creates a file with the Current Date and Current Time. (along with other info) I would like to know how can I update the file with the Current time only? Can I request of...
  22. Replies
    1
    Views
    97

    Re: Win/Loss Percent on visible rows

    Can anyone assist or is this not possible?
  23. Replies
    1
    Views
    97

    Win/Loss Percent on visible rows

    This code displays my Win/Loss Percentage. I'm using an auto-filter macro to filter data and I would like to show my Win/Loss percentage on visible rows only. Can someone assist.

    Thank you...
  24. Replies
    9
    Views
    148

    Re: select item in listbox

    Works great Dante! Thank you both for the help..Cheers
  25. Replies
    9
    Views
    148

    Re: select item in listbox

    Hi Dante, I tried your code, but nothing was selected
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4