Search:

Type: Posts; User: mrmmickle1

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. This code will work.... Please note that the...

    This code will work....

    Please note that the IsNumber Function can be credited to Rick Rothstein.


    Sub Test()

    Dim rng As Range
    Dim cll As Range
    Dim IntLp As Integer
  2. I have had this error in the past as well using:...

    I have had this error in the past as well using:


    Sheets("RawData").Activate
    'AND
    Sheets("RawData").Select

    Would it always be preferable to use the above method?
  3. Try something like this: Sub...

    Try something like this:


    Sub EditFileDirectory()

    Dim path As String
    Dim ThisWB As String
    Dim Filename As String
    Dim Wkb As Workbook
    Dim lastR ...
  4. Wow. This is an older thread, but as far as the...

    Wow. This is an older thread, but as far as the content is concerned it is extremely useful. This thread provides a number of great ways to rearrange columns. I have to say that in the past I was...
  5. You may try using a mixture of these three...

    You may try using a mixture of these three functions: =SUM(F4:F13)-(SMALL(F4:F13,1))/(COUNT(F4:F13)-1)... I can't quite get the order of operations right but I believe this is what you want. It...
  6. Example_Spreadsheet

    Here is a sample spreadsheet. I was almost able to get it to work by adding a few helper columns. I tried to write a function called LookupWinner but I couldn't get it to work correctly. This...
  7. IF STATEMENT BASED ON EQUAL VALUES IN RANGE

    I am trying to compare cells within the range $T$7:$T$47. I look for the max value within this range. If two or 3 cells equal the same value within this range I would like it to compare another set...
  8. ExcelFox, Thank you for the tip. I see how...

    ExcelFox,

    Thank you for the tip. I see how much easier this is and less typing!! I appreciate you following up on my post!
  9. I ended up making a user form for the...

    I ended up making a user form for the depreciation schedule. This is the code I used to complete the automation:


    Private Sub UserForm_Initialize()
    TextBox1.Value = ""
    TextBox2.Value =...
  10. I know that this post was not written well...

    I know that this post was not written well enough. I have reevaluated the process that needs to take place and believe that I have figured out a logical way to go about this process. I have posted...
  11. Activity Based Depreciation If /Then VBA Code

    I am attaching a workbook that contains activity based depreciation formulas.
    I have written notes in it to explain the dilemma. I need to fill in a set of new values based on activity hours....
    I...
  12. Replies
    7
    Views
    5,959

    LalitPandey87 was able to complete the above task...

    LalitPandey87 was able to complete the above task in a very professional manner. The project was completed in a timely manner and it exceeded my expectations. LalitPandey87 is a very talented...
  13. Conditional Format

    Orestees,

    Look at Sheet 1 in the attachment.

    Go to conditional formatting on the Home Tab. Then Click.

    Go to Manage Rules then Click.

    You should understand what to do from there.
  14. Orestees, If you have people editing the...

    Orestees,

    If you have people editing the bottom array in the sheet you may want to lock all of the top cells with these formulas in them....
    typically people will mess things up if you give them...
  15. Put this in D6 and autofill the formula to the...

    Put this in D6 and autofill the formula to the right.

    =IF(ISNUMBER(SEARCH("*Tailor*",D24)),D25, IF(ISNUMBER(SEARCH("*Tailor*", D26)), D27, IF(ISNUMBER(SEARCH("*Tailor*", D28)), D29,...
  16. Put this in D6 and autofill the formula to the...

    Put this in D6 and autofill the formula to the right.

    =IF(ISNUMBER(SEARCH("*Tailor*",D24)),D25, IF(ISNUMBER(SEARCH("*Tailor*", D26)), D27, IF(ISNUMBER(SEARCH("*Tailor*", D28)), D29,...
  17. Replies
    0
    Views
    1,463

    Click On link entitled "Web Timeclock"

    I am trying to click on a link on a webpage.

    There is no ID to identify the link. The only thing in the source code is:

    A href="ee-tawebclock.php?clockid=WEB00">Web TimeClock</A

    I have...
  18. You are very welcome. This excercise helped me...

    You are very welcome. This excercise helped me learn some as well. I may be able to help someone I know who works for a local gym create a better scheduling system too. Up until yesterday I had...
  19. Replies
    3
    Views
    1,986

    To Get THe Format you want you will want to...

    To Get THe Format you want you will want to create a helper column.

    You can paste a conatenation formula in one Column lets say E. This formula will be in E2 =CONCATENATE(B2,C2,D2).

    Once this...
  20. I think I was trying to make it too complicated

    Is this similar to what you wanted?

    Try This in D3:

    =IF(ISNUMBER(SEARCH("*Tinker*",D24)),$B$24, IF(ISNUMBER(SEARCH("*Tinker*", D26)), $B$26, IF(ISNUMBER(SEARCH("*Tinker*", D28)), $B$28,...
  21. Orestees, Try something like this: ...

    Orestees,

    Try something like this:

    =IF(ISNUMBER(SEARCH("*Tinker*",B3)),B24,IF(ISNUMBER(SEARCH("*Tom A*",B3)),B24,"NoTrainerAvailable"))

    You would need to enter all the possible trainers...
    ...
  22. Replies
    7
    Views
    5,959

    IE Automated Login/Table Pull

    I am willing to offer someone $30 USD via Paypal in order to solve the login problem in the below thread:

    IE Automation Thread

    Although I cannot provide my username and password I would be...
  23. Would it be possible to use the Tab index # to...

    Would it be possible to use the Tab index # to click the button:



    <td style="padding-left: 1px;">&nbsp;<input type="submit" value="Log In" id="submitButton"
    name="submitButton"...
  24. Rick, I have the below Procedure that will...

    Rick,

    I have the below Procedure that will fill in the username and password. However it will not let me log in. If I take the portion of the code out that .click and let the procedure run and...
  25. VBA IE Internet Explorer Automation Through ElementID

    I am trying to figure out how to do two things.

    1. Fill in a Login Form Based on an Element ID >>


    Set doc = IE.Document
    Set el = doc.getElementById("someElementId")
    el.value =...
Results 1 to 25 of 51
Page 1 of 3 1 2 3