Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    7
    Views
    325

    Re: Explanation on formula

    Thanks Aladin,

    Understood, but I am still intrigued. Why is that?

    Greemo
  2. Replies
    7
    Views
    325

    Re: Explanation on formula

    Wonderful! Thank you for the explanation and new knowledge RickXL and Rick Rothstein.

    Greemo
  3. Replies
    7
    Views
    325

    Explanation on formula

    Hello, I would just like an explanation on what is going on behind the formulas I have set up. I wanted to set up a formula that would return the last row number in a given cell range. I used...
  4. Replies
    1
    Views
    196

    Excel Formulas to find matching record

    Hello,

    I have two tables which contain records (rows) of unique values. What I need to find is which of the records from Table 1 are in Table 2 but with a specific different value for one of its...
  5. Replies
    2
    Views
    447

    Re: Excel 2013 apply bold with .Replace

    Works wonderfully! Thank you!

    Greemo
  6. Replies
    2
    Views
    447

    Excel 2013 apply bold with .Replace

    Hi,

    I have the following code which makes any cells with strikethrough formatting as blank cells.


    Application.FindFormat.Clear
    Application.FindFormat.Font.Strikethrough = True
    ...
  7. Replies
    4
    Views
    419

    Re: Explanation on VBA Replace syntax

    Ok thank you.

    Would you know how I would apply bold to the search results (all the cells with strikethrough formatting) before the procedure replaces them with "" ?

    Greemo
  8. Replies
    4
    Views
    419

    Re: Explanation on VBA Replace syntax

    I don't understand how VBA is reading the *. Does this mean everything?

    Greemo
  9. Replies
    4
    Views
    419

    Explanation on VBA Replace syntax

    Hello,

    I'm using this following lines of code in excel vba 2013:


    Application.FindFormat.Clear
    Application.FindFormat.Font.Strikethrough = True
    Range("Todo, todoest, tododd").Replace...
  10. Re: Find cells that contain some of text string

    Works great, thank you!

    Greemo
  11. Replies
    2
    Views
    254

    Re: Excel VBA increasing date value

    Ok thank you.

    Greemo
  12. Replies
    2
    Views
    254

    Excel VBA increasing date value

    Hello,

    I have the following line of code:

    Selection.Offset(0, 2).Value = Selection.Offset(0, 1).Value + 1
    It does not add a day to the already existing date as intended but rather changes the...
  13. Re: Find cells that contain some of text string

    Hi gpeacock,

    Thank you. The macro works perfectly! Any way to have it only search at non blank cells to save resources?

    Thank you,

    Greemo
  14. Find cells that contain some of text string

    Hello,

    Can I have some direction on creating an excel macro to select all the cells that start with a specific string of text? Should I use the find tool? This string of text will always be the...
  15. Macro to show hyperlink address as hyperlink text

    Hello,

    I have a line of code that takes the hyperlinks address and shows it as the hyperlink text:



    selection.Hyperlinks(1).texttodisplay = Selection.Hyperlinks(1).Address


    How can I...
  16. Re: Identify specific formatting conditions with VBA

    Bump -

    To clarify: I'm looking to delete only specific formatting conditions while still preserving any other formatting conditions that may be applied. E.g. I want to check if there is an...
  17. Re: Counting with formulas to meet specific conditions

    Perfect! Thank you.

    Greemo
  18. Re: Counting with formulas to meet specific conditions

    Hi AhoyNC,

    I want to extend my table by adding another row (column E). This column would tell me if the staff initials from the table is part of the GROUNDSTAFF range.

    How do I go about this?...
  19. Re: Counting with formulas to meet specific conditions

    Oh! Thank you!

    Greemo
  20. Re: Counting with formulas to meet specific conditions

    This works great! But why the heck does it?

    Greemo
  21. Counting with formulas to meet specific conditions

    Hello,

    I'm using the COUNTIFS formula but am having trouble getting the count to flow. Here is what I have currently:

    =COUNTIFS(B:B,"ground",C:C,"6/28/2014",D:D,GROUNDSTAFF)

    Where:
    - Column...
  22. Re: Identify specific formatting conditions with VBA

    Bump - any help on this?

    Thanks,

    Greemo
  23. Identify specific formatting conditions with VBA

    Hello,

    In my spreadsheet I have a variation of conditional formatting rules applied (that often overlap each other) to specific cells. Sometimes I have an icon set applied on top of another...
  24. Replies
    3
    Views
    106

    Re: Macro Ends When Error Hits

    Works great, thanks.

    Greemo
  25. Replies
    3
    Views
    106

    Macro Ends When Error Hits

    Hello,

    I'm running a macro and this following code is giving me issues:

    Range("ImportDaily").SpecialCells(xlCellTypeBlanks).Delete Shift:=xlUp

    It work's fine except when there are no blank...
Results 1 to 25 of 42
Page 1 of 2 1 2