Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    13
    Views
    296

    Lou, Since Form controls are not active X...

    Lou,

    Since Form controls are not active X controls and cannot encapsulate VBA code, they were outside the scope of this topic. See the following link

    http://support.microsoft.com/kb/291073
  2. Replies
    7
    Views
    154

    Derf, My first code uses the UsedRange...

    Derf,

    My first code uses the UsedRange method. UsedRange is dependent not only by data but also dependent on formatting, comments, etc. On your sheet, you may have cleared some cells of data but...
  3. Replies
    12
    Views
    263

    z, Here is the revised file that will: 1....

    z,

    Here is the revised file that will:
    1. Append the text to the Master sheet
    2. Convert the numbers in column E as you indicated.
    3. Copy and append each line to the worksheet indicated by...
  4. Replies
    12
    Views
    263

    Working on it z. Will have solution completed...

    Working on it z. Will have solution completed tonight or tomorrow
  5. Replies
    8
    Views
    209

    I would have never guessed there would be 50k+...

    I would have never guessed there would be 50k+ rows :)
  6. Replies
    16
    Views
    633

    hmw, The vital signs I entered went from...

    hmw,

    The vital signs I entered went from normal to hypertensive, tachycardic, febrile, and obese with the next set swinging in the other direction of hypotensive, bradycardic, hypothermic, and...
  7. Replies
    16
    Views
    633

    Probably because you have 5000 rows for each on...

    Probably because you have 5000 rows for each on the 5 graphs and that I most likely did not use the most efficient method in my code.

    After playing with this, I found another option you have to...
  8. Replies
    12
    Views
    263

    z, Your welcome. Getting the file name...

    z,

    Your welcome. Getting the file name conversion should be simple enough with a Vlookup from the conversion table. From the zipped CSV file would I be correct to say that you wanted the 4...
  9. Replies
    12
    Views
    263

    z, Sounds doable. Can you provide the...

    z,

    Sounds doable. Can you provide the conversion list of B col values to sheet tab names. If you are sending the values to their perspective worksheet then creating workbooks from them, does it...
  10. Replies
    8
    Views
    209

    foncesa, Change the line: Dim I As Integer,...

    foncesa,

    Change the line:

    Dim I As Integer, J As Integer

    to

    Dim I As Long, J As Long
  11. Replies
    16
    Views
    633

    Lex, The code needs to be placed in the module...

    Lex,

    The code needs to be placed in the module belonging to Data Sheet. You have placed it in a standard module.

    Maud

    40029
  12. Replies
    14
    Views
    262

    For Rory's code to work, the lines: ...

    For Rory's code to work, the lines:


    wkbDSL.Range("B3").PasteSpecial Paste:=xlPasteValues, Operation:=xlMultiply

    need to be changed to

    wkbDSL.ActiveSheet.Range("B3").PasteSpecial...
  13. Replies
    12
    Views
    263

    zmagic, If needed, here is a different...

    zmagic,

    If needed, here is a different approach from Zeddy's. The code will append the text to the Master sheet and convert the numbers in column E as you indicated. It will then copy and append...
  14. Replies
    14
    Views
    262

    A few things to shorten the code further: 1. ...

    A few things to shorten the code further:
    1. After opening the source workbook, once you reactivate the main workbook (ThisWorkbook) you do not have to activate it each time you copy from the...
  15. Replies
    16
    Views
    633

    Lex Vs. Harry, Until you get things...

    Lex Vs. Harry,

    Until you get things straightened out, you can use this code as a workaround. Place in the Data sheet's module. When the date is entered in the next row in column A, the ranges...
  16. Replies
    5
    Views
    143

    Silencer, Following the same concept of...

    Silencer,

    Following the same concept of changing the sheet tab color when a cell change was made to a specific cell:

    If you wish to test the conditional formatting of the cell to determine if...
  17. Replies
    5
    Views
    143

    Silencer, This code will check cell A1 against...

    Silencer,

    This code will check cell A1 against the current date when the workbook is opened. If within 1 week due, the sheet tab will turn red else the sheet tab will have no color. Change [a1]...
  18. Replies
    8
    Views
    209

    Simple change of the 8 to a 7 in line 7 HTH...

    Simple change of the 8 to a 7 in line 7

    HTH
    Maud



    Public Sub FormatCells()
    Dim I As Integer, J As Integer
    LastRow = ActiveSheet.Cells(Rows.Count, 4).End(xlUp).Row
  19. Replies
    3
    Views
    120

    Check out this thread. ...

    Check out this thread.

    http://stackoverflow.com/questions/9879825/how-to-add-a-reference-programmatically-vba-excel

    Coupled with some code to find your excel version you can reference the...
  20. Replies
    3
    Views
    125

    Rathril, I would seriously reconsider buying...

    Rathril,

    I would seriously reconsider buying books for this topic. The move away from paper has been a growing endeavor because it is so cost effective to publish on line. Let's face it, VBA...
  21. Replies
    8
    Views
    209

    foncesa, This code will increment the numbers...

    foncesa,

    This code will increment the numbers in the rows starting at column H using the parameters in Col D and E. It will format each of the cells with leading zeros to have a 6 decimal number....
  22. Replies
    7
    Views
    154

    Derf, I put together a sample sheet with data....

    Derf,

    I put together a sample sheet with data. I am not sure of what kind of data you are using but the following code will adapt. The borders will be created just prior to printing based on the...
  23. Rathril, I believe this will do what you want....

    Rathril,

    I believe this will do what you want. Click on the button on the Day sheet to copy the row to the WEEK and MTD sheets. I also corrected your formulas so you do not get the #DIV/0!...
  24. R2R, I think this should do it Sub...

    R2R,

    I think this should do it



    Sub PrintFooters()
    '-----------------------------------------------
    'REMOVE FOOTER AND PRINT PAGES 1-2
    ActiveSheet.PageSetup.CenterFooter = ""
  25. Replies
    6
    Views
    557

    Dev, Placing this code in the sheet's module...

    Dev,

    Placing this code in the sheet's module will take any value placed in column B, whether manually or programmatically placed there, and enter it into cell D1. Your Vlookup formula will...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4