Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Damien, You could also approach this with a...

    Damien,

    You could also approach this with a UDF (User Defined Function). Paste the following code in a standard module. in cell B1, place the following code =Strip(A1) and copy down.

    HTH,...
  2. Damien, The following code will cycle through...

    Damien,

    The following code will cycle through each character in each cell in column A. If it detects a character that you specify a to strip, it will remove the character from the title and place...
  3. Replies
    2
    Views
    52

    rich, Macro=VBA. If all else fails to find a...

    rich,

    Macro=VBA. If all else fails to find a non-VBA method, the following code will get the URLs from the hyperlinks in Column A and paste it in the adjacent cell. Paste the code into a...
  4. Damien, Can you post your .csv file so we can...

    Damien,

    Can you post your .csv file so we can do some testing? My initial thought is to clean the data with the clean function prior to importing

    On a side note:
    While researching this topic,...
  5. Nicole, The answer to your first question is...

    Nicole,

    The answer to your first question is that I guess it is possible. I would have to give it more thought on how to write the code since the textboxes are created on the fly. As far as the...
  6. Replies
    4
    Views
    94

    [SOLVED] Nicole, As an alternative, you could also use...

    Nicole,

    As an alternative, you could also use a mouseover to display a message in the status bar.

    Maud

    40392
  7. Replies
    4
    Views
    94

    [SOLVED] Nicole, How about something like a Mouseover...

    Nicole,

    How about something like a Mouseover message that appears like a comment to a cell. Using a rectangular shape formatted to the way you want with the desired text added, move it next to...
  8. Trevor, What are your requirements to be able...

    Trevor,

    What are your requirements to be able to see more of the data? Maybe there is something out there that can do what you want to do.
  9. BygAuldByrd, Maybe something like this may be...

    BygAuldByrd,

    Maybe something like this may be helpful. You can toggle the graphs to be displayed or to be hidden if you want access to the data below it. Toggling back and forth will not change...
  10. CACI, I will point you in the right direction...

    CACI,

    I will point you in the right direction and let you take it from there

    Cell D1 has the comment. A msgbox will return True if the value in Cell A1 is contained in the comment and False if...
  11. Howard, When you get to the J loop, you are...

    Howard,

    When you get to the J loop, you are starting back at row 3 and duplicating the first loop therefore doubling your numbers.

    Change
    For J = 3 To Lr1
    to
    For J = 16 To Lr1

    That...
  12. Make sure the scroll lock is off

    Make sure the scroll lock is off
  13. Replies
    7
    Views
    290

    Mostate, If you want to correct the format of...

    Mostate,

    If you want to correct the format of the value within the same cell and not having to use a formula in a different cell, place the following code in the sheet's module:



    Private Sub...
  14. Replies
    17
    Views
    512

    Additional questions: Will they be open...

    Additional questions:
    Will they be open simultaneously?
    How do you validate if they are marked as "checked"?
  15. Here is the final revision that adjusts the line...

    Here is the final revision that adjusts the line to the correct position when outdenting from a Subsection to a Section,
  16. Replies
    3
    Views
    83

    [SOLVED] Nicole, You could use the following formula: ...

    Nicole,

    You could use the following formula:

    =COUNTIF(CHOOSE(B1,C1:C5,C1:C10,C1:C15,C1:C20),"X")

    40344

    HTH,
    Maud
  17. James, An alternate approach to using formulas...

    James,

    An alternate approach to using formulas as Zeddy did in his EXCELLENT spreadsheet is the VBA approach which is allows a more dynamic and fully automated application than formulas can...
  18. Replies
    9
    Views
    329

    CACI, Here is a search routine I wrote a while...

    CACI,

    Here is a search routine I wrote a while back but adjusted it to highlight the keyword. See if something like this would work for you.

    In the search box (yellow), type your keyword. ...
  19. Replies
    4
    Views
    154

    [SOLVED] T, You could just add the following line to...

    T,

    You could just add the following line to the end of your code:

    ActiveWindow.SmallScroll up:=17

    It will move your top row from 37 to 20

    HTH,
    Maud
  20. Replies
    22
    Views
    871

    If you were in a falling elevator, why not jump...

    If you were in a falling elevator, why not jump just prior to the moment the elevator hits the ground?
  21. Paul, My guess is that he already has the...

    Paul,

    My guess is that he already has the numbers in a debit column which is why they need to be positive numbers. I would seem that a negative debit equates to a double negative
  22. Replies
    8
    Views
    268

    Bill, To avoid having to enter the formula...

    Bill,

    To avoid having to enter the formula with each new entry, you can copy this modified formula down to the bottom.

    In cell E2 enter =IF(D2="","",$E1+$D2)

    The formula will just sit there...
  23. Perhaps changing the line: Set rngCurrent =...

    Perhaps changing the line:


    Set rngCurrent = Range("D2")

    to

    Set rngCurrent = ActiveCell

    might make it a little easier than changing the start cell in the code. Simply select the first...
  24. Yes, I see now what you are saying...strange!

    Yes, I see now what you are saying...strange!
  25. To get rid of the hyphen try Public Sub...

    To get rid of the hyphen try



    Public Sub TrimName()
    ActiveWorkbook.Windows(1).Caption = Null
    Application.Caption = ActiveWorkbook.Name
    End Sub
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4