Search:

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

Page 1 of 8 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    30
    Views
    2,528

    To import is the easy part Sub ImportSampleTXT()...

    To import is the easy part
    Sub ImportSampleTXT()
    With ActiveSheet.QueryTables.Add(Connection:="TEXT;C:\yourfolder\SAMPLE.txt", _
    Destination:=Range("a1"))
    .RefreshStyle =...
  2. Replies
    13
    Views
    249

    trying again

    trying again
  3. Replies
    4
    Views
    135

    [SOLVED] http://chandoo.org/wp/2010/11/30/excel-animation-w...

    http://chandoo.org/wp/2010/11/30/excel-animation-without-macros/
  4. Replies
    13
    Views
    249

    See attached for another way

    See attached for another way
  5. Replies
    13
    Views
    249

    You had the formulas messed up in the middle of...

    You had the formulas messed up in the middle of the column. Use ATTACHED
  6. What is this for?

    What is this for?
  7. Replies
    13
    Views
    249

    If it is UNIQUE matches you want you can modify...

    If it is UNIQUE matches you want you can modify your row 2 formulas to
    =IF(COUNTIF(A$2:A2,A2)>1,"",VLOOKUP($A2,INPUT!A:J,1))
    also suggest you have a defined name for the lookuprange so you don't...
  8. No such shown in sample ????

    No such shown in sample ????
  9. Replies
    3
    Views
    450

    Another '========= Option Explicit Sub...

    Another
    '=========
    Option Explicit
    Sub values()
    Dim asn As String
    Application.ScreenUpdating = 0
    asn = ActiveSheet.Name
    Worksheets.Add(After:=Sheets(asn)).Name = asn & "_V"...
  10. Appreciate the comment

    Appreciate the comment
  11. Replies
    25
    Views
    1,024

    OK, I did as you suggested, blanking those cells...

    OK, I did as you suggested, blanking those cells with the delete key, and it still works ???????
  12. Replies
    25
    Views
    1,024

    Zeddy, I don't understand what you are saying....

    Zeddy, I don't understand what you are saying. Send me privately if desired.
  13. Replies
    2
    Views
    94

    Maybe I don't understand but if a web QUERY...

    Maybe I don't understand but if a web QUERY simply right click anywhere in the query and select refresh at the bottom.
  14. Replies
    25
    Views
    1,024

    Try this. It will find and cancel duplicates in...

    Try this. It will find and cancel duplicates in col a-f. If you only want the same column, change accoringly
    '=========
    Option Explicit
    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim lr...
  15. Use a macro to copy to sh1 from sh2. Save file as...

    Use a macro to copy to sh1 from sh2. Save file as .xlsm or


    Option Explicit
    Sub CopyEm()
    Dim i As Long
    Dim dr As Long
    For i = 15 To Cells(Rows.Count, 1).End(xlUp).Row Step 7
    dr =...
  16. Reasons not to use shortcut method and what if...

    Reasons not to use shortcut method and what if another advanced filter used filtering elsewhere and unique.

    Memory Considerations:
    While it may be thought that shortcut notation (being much...
  17. KISS Sub FilterONLYWholeNumbers()...

    KISS
    Sub FilterONLYWholeNumbers()
    Range("c2").Formula = "=INT(A2)=A2" Columns(1).AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=Range("C1:C2"), _
    Unique:=False
    Range("c2").ClearContents...
  18. Time to attach your file along with a clear...

    Time to attach your file along with a clear explanation and before/after examples.
  19. Replies
    41
    Views
    1,723

    Zeddy, When is hte last time you cleaned out...

    Zeddy,

    When is hte last time you cleaned out your temp files, especially with .exd extension ?
    or
    vba tools>references> object libraries??
  20. Replies
    41
    Views
    1,723

    Zeddy, Nothing wrong with your xl2003. I got...

    Zeddy,
    Nothing wrong with your xl2003. I got the same STRANGE result. This is, despite having almost all versions of xl installed on the same computer, I still use 03 for most development. I then...
  21. Replies
    41
    Views
    1,723

    This should make you happy. Use RIGHT click if...

    This should make you happy. Use RIGHT click if you only want ONE click.
    Sorts both ways.

    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    If Range("h1") = 1...
  22. Replies
    2
    Views
    85

    Copy this to the sheet module and save your...

    Copy this to the sheet module and save your workbook as .xlsM or .xlsB


    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address <> Range("a1").Address Then Exit Sub...
  23. Replies
    2
    Views
    461

    Do you want to hide ONE row or many with the...

    Do you want to hide ONE row or many with the toggle? And, if you hide the same row as the cell used to hide the row with the toggle then how could you select to unhide if it is hidden?
    Perhaps you...
  24. Replies
    41
    Views
    1,723

    Me thinks both of you guys are being a bit wordy...

    Me thinks both of you guys are being a bit wordy or why say 47 when 4 score and 20 years will do.
    If you want to sort by any column in the current region simply put this in the sheet module and...
  25. Replies
    41
    Views
    1,723

    I don't know that you will be getting additional...

    I don't know that you will be getting additional replies.
Results 1 to 25 of 192
Page 1 of 8 1 2 3 4