Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. I was able to download the file from the post,...

    I was able to download the file from the post, rename the extension to .xlsb, and open the file successfully in Excel.
  2. find a way to upload an unsupported file

    Upload an xlsb file renamed in Windows explorer to xlsm
  3. Replies
    4
    Views
    153

    [SOLVED] X_LD, I added a third animation where the...

    X_LD,

    I added a third animation where the averages for the categories are progressively calculated from top to bottom. Has an equalizer effect.

    Maud
  4. KW, Is this the long way or short way? ...

    KW,

    Is this the long way or short way?

    Maud

    42425
  5. Jaggi, Here is a UDF to extract your term. ...

    Jaggi,

    Here is a UDF to extract your term. Use the formula =Term(range) where range is the cell with the term you wish to extract. Copy down if applicable. As long as the structure of the...
  6. Replies
    32
    Views
    2,557

    A man of your word, "30 lines or less". Very...

    A man of your word, "30 lines or less". Very nice job Zeddy
  7. Replies
    4
    Views
    153

    [SOLVED] X_LD, Here is some code that animates a...

    X_LD,

    Here is some code that animates a horizontal bar graph. I have 50 rows in my samples and using a bar graph looks quite cluttered. Are you sure you want a bar graph with 250 rows? Perhaps...
  8. To convert 19470302 in cell D3 to 3/2/1947 in the...

    To convert 19470302 in cell D3 to 3/2/1947 in the same cell D3, you can use the following code:



    Sub convertDates()
    Range("D3") = Format(Range("D3"), "####-##-##")
    Range("D3") =...
  9. Replies
    5
    Views
    190

    RSring, Just be careful. Average can...

    RSring,

    Just be careful. Average can accommodate blanks but it can't for zeros.

    42398
  10. Replies
    1
    Views
    49

    If you post the problematic code, we night have a...

    If you post the problematic code, we night have a better chance of diagnosing the cause.

    Maud
  11. Kerryg, Since I had been working on a...

    Kerryg,

    Since I had been working on a solution, I will post mine as well. The code accepts x or X for the checkboxes and validates any other value entered. The code will then hide the question...
  12. Megan, I think this should do the trick! It...

    Megan,

    I think this should do the trick! It will cycle through all 5 sections when the workbook opens,

    Maud
  13. Magan, Right off the bat, the Workbook_Open...

    Magan,

    Right off the bat, the Workbook_Open event is sitting in a worksheet module. It should reside in the ThisWorkbook module where it will run when the workbook is opened. As of right now, it...
  14. Replies
    25
    Views
    1,062

    Math, The following workbook uses no VBA. It...

    Math,

    The following workbook uses no VBA. It has a second hidden sheet where column A is the concatenation of the first 5 columns of each row from sheet 1. Column B on sheet 2 contains the...
  15. Assuming that .cells(1,1) contains- Injury:...

    Assuming that .cells(1,1) contains- Injury: Strain To: Lower Back Area

    the line of code would be: .Cells(dr, 7).Value = Mid(.Cells(1, 1), 9, 6)

    Maud
  16. Replies
    25
    Views
    1,062

    Zeddy, I must admit that your code is...

    Zeddy,

    I must admit that your code is impressive but since you quoted the OP, there was no mention to inspect or to clean an existing database with duplicates which is a whole other set of code...
  17. Replies
    15
    Views
    555

    Perhaps left over from 16 bit programming where...

    Perhaps left over from 16 bit programming where either the first or the last bit was used as a pointer.
  18. Replies
    11
    Views
    1,020

    Good morning Mr. Phelps! I totally missed that...

    Good morning Mr. Phelps! I totally missed that possibility. Good thinking. Just wondering, how many other shooters do you think there would be?

    access- Impulsively, I'd take the shot at Mr....
  19. Replies
    7
    Views
    236

    Here is a way to generate your own random names....

    Here is a way to generate your own random names.

    42296



    Public Sub MaleName()
    Randomize
    num = Int((200 * Rnd) + 1)
    x = WorksheetFunction.VLookup(num, Range("A2:B201"), 2)
  20. Replies
    7
    Views
    236

    I would think that a random number could be...

    I would think that a random number could be generated between certain values then use a VLookup to return the name next to it. Would not be difficult to construct if you have a large available list...
  21. Replies
    25
    Views
    1,062

    Not really sure what you are driving at there. ...

    Not really sure what you are driving at there.

    Not to beat a dead horse but in my sample, if you copy a row (A:F) then paste it in a new row, it will still alert. To avoid typing an entire row of...
  22. Replies
    25
    Views
    1,062

    Zeddy, A simple "non-tricky" method to meet...

    Zeddy,

    A simple "non-tricky" method to meet your objection using one line of code is to clear the cell (last entry) and not the whole row, since it is the last entry that makes it a duplicate.
    ...
  23. Replies
    15
    Views
    555

    for visual purposes only.

    for visual purposes only.
  24. Replies
    15
    Views
    555

    You can still do calculations on it by changing...

    You can still do calculations on it by changing it back to a value, performing the calculation, and then converting it back to text

    =TEXT(VALUE(C1)*2,"#")

    42278

    In the calculation, however,...
  25. Replies
    25
    Views
    1,062

    Math, Here is my revised version to...

    Math,

    Here is my revised version to accommodate the additional columns you specified.

    HTH,
    Maud
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4