• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by Luke M

  1. Luke M

    Adding XL version

    @Hui Any luck on finding the setting to display this information and let it be seen by others?
  2. Luke M

    Adding XL version

    Thanks Hui. I see under Preferences where we can enable something, but like the others I don't see that info being displayed anywhere.
  3. Luke M

    Adding XL version

    Status update: Sadly, I've not been able to get a hold of Chandoo or anyone who can actually implement the change to the forums. Continuing to try and reach out. Maybe they're on travel? :(
  4. Luke M

    Adding XL version

    Thanks for the info, this helps!
  5. Luke M

    Adding XL version

    Sorry pecoflyer, but I have been researching and trying to see if that's an option with our current platform. I can see and we've discussed porting to a different forum platform, but so far that is being considered a larger undertaking than we want to do for just a "quality of life" improvement...
  6. Luke M

    Adding XL version

    Hello everyone. Sorry for not seeing this until today; long weekend for me. I agree that conveying what version of Excel someone is using is a key piece of information. With the current forum tools available, there's certainly nothing stopping us from including that info in a signature. You...
  7. Luke M

    Balance Amount Continue

    Formula in H6 should be =H5+G6 and then copy that down.
  8. Luke M

    Nesting formula help!

    Rather than trying to understand your method, what's the goal? To check if value in col A is the first letter of col B? =AND(A2<>"",LEFT(B2)=A2)
  9. Luke M

    Number formatting does not seem to work

    After review, this question is a follow-up to previous; not a duplicate. Thread re-opened.
  10. Luke M

    Calculation speed of formula

    Appears to be duplicate/similar to: Improve spreadsheet design | Chandoo.org Excel Forums - Become Awesome in Excel
  11. Luke M

    Changing the values from Indian Rupees to Dollars with correct spacing

    @KSKwin This thread is 8 years old. I suggest starting your own new thread where it will have more visibility.
  12. Luke M

    Send email (with VBA) and update "status"

    Sorry about that. Marc is correct, remove the leading period.
  13. Luke M

    Send email (with VBA) and update "status"

    Edit: Typo Sub SendEmails() Dim lastRow As Long Dim OutApp As Object Dim OutMail As Object Dim strbody As String Dim i As Long Set OutApp = CreateObject("Outlook.Application") 'How much data is there? lastRow = Cells(Rows.Count, "A").End(xlUp).Row...
Back
Top