Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    2
    Views
    206

    Re: Macro to open serveral files

    Not sure if I correctly understood you, but this is the code which shows the last file selected. Note, however, that this is not a last file selected by user, but last file in list (which is...
  2. Replies
    14
    Views
    582

    Re: Extract names before and after a /

    Variables name1, name2 and name3 hold the found names:


    Sub FindNames()


    Dim name1$, name2$, name3$
    Dim re As Object 'RegExp
    Dim mc As Object 'MatchCollection
    Dim m As...
  3. Replies
    3
    Views
    315

    Re: How to run macro only selected rows

    Alas, there's no way to calculate arbitrary range. Either everything is calculated or none (although there's option to calculate except Data Tables, but this is irrelevant to your need).
  4. Re: Copy selected items to a contiguous list ion another worksheet

    Anything to show?
  5. Replies
    4
    Views
    203

    Re: Converting Decimals to Age

    You need VBA or formula?
  6. Replies
    11
    Views
    480

    Re: Macro to find last instance of today's date

    Change date to the one you need


    Sub FindLastDate()
    Dim dtSearch As Date
    Dim cell As Range
    dtSearch = DateTime.DateSerial(2018, 5, 6)
    Set cell =...
  7. Replies
    6
    Views
    297

    Re: Count values and list them

    Beg your pardon, but could not really understand what and where "extract"...
  8. Replies
    1
    Views
    144

    Re: Create a floating bar column

    Would Area chart type fit to you?
  9. Replies
    3
    Views
    175

    Re: Count filtered rows with no value

    You want to know the count of filtered range?
  10. Re: Apply filter on the basis of multiple values

    Sub F()
    With Range("A1").CurrentRegion
    .AutoFilter Field:=1, Criteria1:=Array("India", "Australia"), Operator:=xlFilterValues
    .Copy Sheets.Add().Cells(1)
    End With
    End Sub
  11. Replies
    14
    Views
    344

    Re: sum formula needed

    You're welcome! http://i.smiles2k.net/aiwan_smiles/hi.gif
  12. Replies
    14
    Views
    344

    Re: sum formula needed

    kelly mort
    What about my answer?
  13. Replies
    14
    Views
    344

    Re: sum formula needed

    =SUMIFS(C:C,A:A,"no",B:B,"male")
  14. Replies
    7
    Views
    248

    Re: Data Validation based on cell value

    Data Validation won't help you because it dynamically list to validate against. You need VBA code to do it.
  15. Replies
    11
    Views
    532

    Re: Hold Tag Auto Populate

    Well, you need VBA code to move data from one sheet to another http://www.yaplakal.com/html/emoticons/umnik.gif
  16. Re: Filter Multiple Sheets based on single cell Value in VBA

    Since autofilter accepts only U.S. format date string, you need to format the date accordingly:
    xWs.Range("x6").AutoFilter 1, Format(Sheets("Sheet1").Range("A3"), "mm\/dd\/yyyy")
  17. Replies
    8
    Views
    303

    Re: Change last row of table to capitals

    @Rick
    What's the catch? http://www.yaplakal.com/html/emoticons/upset.gif In your code you assign result of Evaluate back to Range variable? Am I correct?
  18. Replies
    8
    Views
    303

    Re: Change last row of table to capitals

    This doesn't work with FULL row.
  19. Replies
    8
    Views
    303

    Re: Change last row of table to capitals

    Sub MakeUCase()


    Dim BottomRow As Long
    Dim rngBottom As Range
    Dim i As Long
    Dim lastCol As Long
    'find next available row to update data in the data worksheet
    ...
  20. Replies
    3
    Views
    211

    Re: Need Help pulling a specific text/number from a cell

    http://i.smiles2k.net/aiwan_smiles/hi.gif
  21. Replies
    3
    Views
    211

    Re: Need Help pulling a specific text/number from a cell

    UDF (user-defined formula) - use it like regular formula:


    Function GetCode(cell)
    With CreateObject("VBScript.RegExp")
    .Pattern = "A\d{4}"
    With .Execute(cell)
    ...
  22. Replies
    9
    Views
    294

    Re: Adjust Chart for all WorkSheets VBA

    Yes, it requires VBA. Here is the sample code which fills chart with values.
  23. Replies
    9
    Views
    294

    Re: Adjust Chart for all WorkSheets VBA

    If the range is the same for all worksheets, then there's a way to fill chart with actual values (rather binding it to sheet's range).
    Could you post the sample workbook to some cloud storage (with...
  24. Replies
    9
    Views
    294

    Re: Adjust Chart for all WorkSheets VBA

    Why would you need paste charts? Wouldn't it better to create a chart one time and adjust it to range?
  25. Re: Loop 2 Ranges - "Invalid Next Control Variable Reference"

    Could be simplified further: mycell.Value = IIf(myrange.Value = "ATG", "True", "False")
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4