Search:

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

Search: Search took 0.00 seconds.

  1. Re: Show Custom Ribbon as default item on startup

    Yes.

    The answer to this question is embarrassingly simple. One can make the custom tab the first one on the ribbon by changing the XML <tab> line to:
    <tab id="tabDO" label="Coltar"...
  2. Replies
    2
    Views
    116

    Re: Workbook & File SaveCopyAs

    Thank you. I'll give it a read.
  3. Replies
    2
    Views
    116

    Workbook & File SaveCopyAs

    Hi,
    I have a workbook that is being used as a template for data entry and then uses File SaveAsCopy and File SaveAs xlsx macros to concatenate the filename per file naming parameters set by...
  4. Thread: Icons

    by dfolzenlogen
    Replies
    0
    Views
    452

    Icons

    Can anyone suggest a good source for icons? I'm wanting to add some macros to the a tab as a customization to the Excel ribbon.

    Thanks.
  5. Replies
    3
    Views
    190

    Re: Weird Worksheet Protection going on

    Yes, it is macro enable. What should I check or change?
  6. Replies
    3
    Views
    190

    Weird Worksheet Protection going on

    I have something weird going on with a spreadsheet that I'm working in and given to me by a co-worker to complete. If I open the spreadsheet, it is not password protected. I am able to change...
  7. Re: Index Match formula and absolute column reference issues

    Thanks Christontm. I actually am pulling data from several columns and the columns are not in consecutive order in the new spreadsheet (MIPA). Do I understand that you mean for me to use named...
  8. Index Match formula and absolute column reference issues

    Hi,
    I have a workbook which contains 2 worksheets: 1 called MIPA and another called Dashboard Data. I am using Index Match formulas on several columns on the MIPA worksheet which refers to a named...
  9. Replies
    7
    Views
    374

    Re: Combine / concatenate data

    Hi Joe4,

    Love that you comment your code. It sure helps newbies like me understand what's going on!

    Thanks for your posts.

    D
  10. Re: Split delimited data in one cell to multiple rows using macro & apply to whole column

    Thanks to both Mumps and Rick!! Both methods worked beautifully. I appreciate you!!

    D
  11. Split delimited data in one cell to multiple rows using macro & apply to whole column

    Hi All,

    I routinely have a column of data which is quite lengthy with each cell in that data containing numerous names separated by a ";". I want to split those names to individual rows to a 2nd...
  12. Re: Hyperliinks are not standard "Hyperlink blue"

    To All,

    I solved the issue quite by accident. Here's what I did:


    right click on one of the hyperlinks ==>Quick Analysis==>Clear Formats

    All the hyperlinks are "reset" to "Hyperlink blue"....
  13. Hyperliinks are not standard "Hyperlink blue"

    I'm hoping someone can help. I copied and pasted a long list of hyperlinks to a new spreadsheet in Excel 2016 in my Windows 2010 OS. The hyperlinks are now a mix of colors. Some are the standard...
  14. Replies
    0
    Views
    120

    Merge Cells/Rows (Revisited)

    I am trying to merge cells from several rows similar cobbling together code from the response from Michal M to the post of Robert Dino on June 25, 2017. See link to post below:
    ...
  15. Replies
    4
    Views
    404

    Re: Remove Trailing Semicolons

    Thank you Peter!!!:nya:
  16. Replies
    4
    Views
    404

    Remove Trailing Semicolons

    I found the following formula for removing trailing commas on this site:

    Sub RemoveTrailingCommas_Version1()
    Dim Cell As Range
    For Each Cell In Selection
    Cell.Value =...
  17. Replies
    1
    Views
    2,654

    Re: VBA code to merge rows

    My earlier post inadvertently said Document Type when it should have said Book Type. Apologies.
  18. Replies
    1
    Views
    2,654

    VBA code to merge rows

    Hello,

    I am trying to merge cells in rows based on the value of the cell in Column A of my spreadsheet (containing Document Type) through the continuous rows containing no Document Type in Column...
  19. Replies
    4
    Views
    146

    Re: Splitting Text to Multiple Cells

    ok. I feel like an idiot. The column where I was entering the formula was formatted as text rather than General. Works like a charm now.
    Thanks for your help though!

    D
  20. Replies
    4
    Views
    146

    Re: Splitting Text to Multiple Cells

    Thanks for your quick response.

    The following is being returned to the cell:


    =SplitMe(G21,1,10)
    =SplitMe(G21,2,10)
    =SplitMe(G21,3,10)
    =SplitMe(G21,4,10)
  21. Replies
    4
    Views
    146

    Splitting Text to Multiple Cells

    This may be a dumb question but here goes! I purchased Allen Wyatt's ExcelTips and was trying to implement a User Defined Function referenced there for Splitting Text to Multiple Cells. I copied...
  22. Replies
    3
    Views
    270

    Re: Find and Replace, Format and Offset?

    Thank you Joe! Worked like a charm. Thanks for your help. I hope there's a day when I "get this". I did add 2 lines of code at the end.

    Sub test()
    Dim ws As Worksheet, R As Range
    For Each...
  23. Replies
    3
    Views
    270

    Find and Replace, Format and Offset?

    Does anyone have any suggestions for me?
    I have multiple worksheets in my workbook
    each worksheet contains 2 columns with text in Column A, numbers in Column B
    The length of the columns vary...
  24. Re: Finding cell in Row with most data and entering CHAR(10)

    Thank you! I will give it a try!
  25. Finding cell in Row with most data and entering CHAR(10)

    I have a spreadsheet with 10 columns containing hyperlinks, dates and wrapped text. The text cells vary in length. I need to determine which of the text cells contains the most data and then...
Results 1 to 25 of 25