Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Re: If Chip Pearson's website ever helped you, please jot a note...

    thanks for all your contributions to the world of Excel, Chip.
  2. Replies
    5
    Views
    340

    re: TRIM using VBA

    Sub CleanCells()

    Dim cll As Range

    For Each cll In Worksheets("Sheet1").Columns(1).SpecialCells(xlCellTypeConstants, 23)
    cll = CleanTrim(cll)
    Next cll

    End Sub
  3. Replies
    1
    Views
    229

    Re: Search in workbook using row number

    the value of the variable "test" is also the row number.
  4. Re: Macro for copying multiple cells from one worksheet to another

    replied at crosspost:

    Macro for copying multiple cells from one worksheet to another
  5. Re: Percentage of new highs (simple array please)

    hi chipps

    what is wrong with Column B as a helper column?
  6. Replies
    2
    Views
    204

    Re: Email and string space removal

    please use 'code tags' when posting code here.

    perhaps

    Recip = Replace(Cells(ctr, 6), " ", "") & "@sms.htkmessaging.com"
  7. Replies
    2
    Views
    1,524

    Re: change the major units in X axes vba

    crosposted:
    Change the major units in X axes in chart(vba)

    please refer to cross posting etiquette.
  8. Re: Macro Needed to Extract Data from Multiple Workbooks

    you are welcome.

    my bad. i replaced the variable names in the original code for easy understanding. but it seems i missed one.

    and since the array is filtered, "-1" in the loop is redundant.
    ...
  9. Re: Is there an easy way to condense 6 arrays into 1 please.

    you are welcome. glad it helped.
  10. Re: Is there an easy way to condense 6 arrays into 1 please.

    though i dont understand why you create 5 identical arrays and now want to combine them in one, here is a way to do that...




    Sub mrxl_922130_multi1Darr_to_single2Darr()

    Dim A As...
  11. Re: Macro Needed to Extract Data from Multiple Workbooks

    welcome to the forum.
    try this



    Sub mrxl_922184_parse_same_range_from_files()
    'adopted :...
  12. Replies
    5
    Views
    16,839

    Re: Printing in Color with VBA

    does this help?

    http://www.mrexcel.com/forum/excel-questions/684859-help-w-visual-basic-applications-open-dialog-box-select-color-printer-list-change-setup.html
  13. Re: Copy selected items from Listbox to multiple ranges

    assuming there is only one table in sheet stock and D4 is not blank



    If ListBox2.Selected(i) = True Then
    Worksheets("Issued").Range("B" & Rows.Count).End(xlUp).Offset(1).Value =...
  14. Replies
    6
    Views
    405

    Re: Move data without deleting rows

    posted to the thread at vbax too...



    Sub mrxl_880357_CutPasteDeleteRange()
    Range("A2:A100").Cut Destination:=Range("E" & Rows.Count).End(xlUp).Offset(1)
    Range("A2:A100").Delete...
  15. Replies
    6
    Views
    198

    Re: return store assoc. for selected store #

    welcome to MrExcel.

    check this:
    Vlookup Multiple Values - Return MULTIPLE corresponding values for ONE Lookup Value
  16. Thread: VBA Code

    by mancubus
    Replies
    6
    Views
    192

    Re: VBA Code

    you are welcome.

    i am still learning. :)

    but there are 'supernovas' here and on other communties. :)
  17. Thread: VBA Code

    by mancubus
    Replies
    6
    Views
    192

    Re: VBA Code

    below worked for me:



    Private Sub Worksheet_Change(ByVal Target As Range)
    If Intersect(Target, Range("S19:S29")) Is Nothing Then Exit Sub
    Range("S19:S29").Copy...
  18. Thread: VBA Code

    by mancubus
    Replies
    6
    Views
    192

    Re: VBA Code

    welcome to the forum. please use code tags when pasting your code.
    # button inserts code tags...


    try like:


    Private Sub Worksheet_Change(ByVal Target As Range)

    If Not...
  19. Re: Highlight most frequent cell values in the row

    hi.

    conditional format:

    microsoft excel - Conditional Formatting to highlight cells with highest frequency - Super User
  20. Re: VBA to filter data in a source file using data from another workbook then create new filtered data tabs

    cross posted:
    VBA to filter data in a source file using data from another workbook then create new

    please follow the cross posting etiquette as described in the link in the above thread.
  21. Replies
    2
    Views
    382

    Re: vba rows to columns for addresses

    hey.
    i've been working on this. :)

    writes concatenated values of cells to column C in the same sheet.



    Sub mrxl_854289_multiCell_to_singleCell()

    Dim ar As Range
  22. Re: What is the VBA code to Filter out the dates Less than year 2014?

    i assume topleft cell is A1 and date format in international settings is european date format (DMY)

    i'm copying 2 codes that i use regularly for different purposes.



    Sub FilterOnDateCopy()
    ...
  23. Re: Problem copying data to next available row with VBA

    i aproach to requirement would be:



    Sub mrxl_851986_ConsWss()

    Dim wsNames As Variant
    Dim copyRange As Range
    Dim i As Long
  24. Re: Problem copying data to next available row with VBA

    hi...


    emptyRow = destination.Range("A" & Rows.Count).End(xlUp).Offset(1).Row
  25. Replies
    3
    Views
    359

    Re: how to track named ranges in chart

    see my reply with attached file at: named range tracking via VB



    Sub vbax_52434_ChartSeriesSourceData()

    Dim wbNamedRanges()
    Dim cht As ChartObject
    Dim SeriesFormula As String,...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4