Search:

Type: Posts; User: Anne Troy; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Re: Can't Correct Code Send Email via Outlook using Excel Code

    Dang. lost my reply. Here it is again:

    If you'd seen it, you might not have made me try it again!

    GREAT to see you as well.
  2. Re: Can't Correct Code Send Email via Outlook using Excel Code

    Hey, girl!!

    Yep. I tried that as stated in my post. :(
    I think I missed the (1) part....

    This worked:


    On Error Resume Next
    With OutMail
  3. Can't Correct Code Send Email via Outlook using Excel Code

    I'm using Outlook locally with 2 accounts.
    I want to send emails programatically using the "non-default" account.
    I checked out "SendUsingAccount", but wasn't able to make that work.
    Anyone know...
  4. Replies
    7
    Views
    662

    Re: Office 365: Online -vs- Local

    My question isn't how to screen share.
    My question is in the post.
    HOW DO I ENSURE SHE IS RUNNING LOCAL INSTEAD OF ONLINE?
    Whether I can see her screen or not, I still don't know how to force...
  5. Replies
    7
    Views
    662

    Re: Office 365: Online -vs- Local

    I have used Joinme. The issue isn't sharing her screen. Repeat: How can I tell -- by talking to someone over the phone -- if they have a local install of Excel?
    I do not know how to tell, much less...
  6. Replies
    7
    Views
    662

    Office 365: Online -vs- Local

    How can I tell -- by talking to someone over the phone -- if they have a local install of Excel?

    I've sent 2 people a macro file and the macros don't work. I believe they're using the online...
  7. Replies
    6
    Views
    257

    Re: sorting column and expanding selection

    Thank so much for letting me yoink your code! :)
  8. Replies
    13
    Views
    669

    Re: Subtract X hours from entered value

    Okay!

    My first problem was a disappearing immediate window. God knows why. I don't believe I've ever used it on this PC. I got it back using these instructions:...
  9. Replies
    13
    Views
    669

    Re: Subtract X hours from entered value

    Excellent instructions. I've done this before. But when I hit F8, I just get yelled at. :)
    Your latest piece of code still does nothing. I know this is very annoying.
  10. Replies
    13
    Views
    669

    Re: Subtract X hours from entered value

    How do I step through code that runs on a worksheet_change? I just get object not defined errors.
    It acts like it's doing something for the briefest second, but the value that comes back is the same...
  11. Replies
    13
    Views
    669

    Re: Subtract X hours from entered value

    This does nothing as well, Jim. Very strange. I think I'm going to enter it into one range, have a formula in another, and auto-copy the value. This is nuts. Thanks so much!
  12. Replies
    13
    Views
    669

    Re: Subtract X hours from entered value

    Joe, thanks. I gave that a shot. It does the same as mine. Nothing. LOL
  13. Replies
    13
    Views
    669

    Subtract X hours from entered value

    In a cell called offtime, I will enter 2 or 3, depending on the time of year. This indicates that I (on the east coast) am 2 or 3 hours later than the time in Phoenix AZ.

    In my worksheet column K,...
  14. Thread: Error 438

    by Anne Troy
    Replies
    5
    Views
    248

    Re: Error 438

    Nice! I will check it out. :)

    Thanks so much!!
  15. Thread: Error 438

    by Anne Troy
    Replies
    5
    Views
    248

    Error 438

    No clue why this works on my machine, but throws a 438 on another user's machine. Anybody? This is all my code. It's my boss, so I didn't exactly want to get him involved in debugging. Let me know if...
  16. Re: VBA code to add a prefix in all files in a folder

    Rick, thanks for the code!
  17. Replies
    8
    Views
    220

    Re: Count unique by date/time stamp

    Yes yes yes Yes yes yes Yes yes yes Yes yes yes Yes yes yes Yes yes yes Yes yes yes Yes yes yes Yes yes yes Yes yes yes Yes yes yes Yes yes yes Yes yes yes Yes yes yes Yes yes yes Yes yes yes Yes yes...
  18. Replies
    8
    Views
    220

    Re: Count unique by date/time stamp

    Oh, I did do the CSE. Checking out the -1 you gave. :D
  19. Replies
    8
    Views
    220

    Re: Count unique by date/time stamp

    That works GREAT. Now, I just need to subtract one from it, but keep getting a #VALUE error.
    Still trying...
  20. Replies
    8
    Views
    220

    Re: Count unique by date/time stamp

    Yes, Aladin, thanks!

    I'd like to have the airline count in the first row of each new timestamp.
  21. Replies
    8
    Views
    220

    Count unique by date/time stamp

    Sample file: http://annetroy.com/mrexcel/Sample2.xlsx

    Countif and Sumif have always been my nemesis.

    I need to count how many unique airlines are listed in column G, each time the timestamp...
  22. Replies
    7
    Views
    120

    Re: Prefer Formula Solution to lookup value

    Sure does! Perfect.
  23. Replies
    7
    Views
    120

    Re: Prefer Formula Solution to lookup value

    That's beautiful, Weazel. I didn't even get a chance to give my sample file link. www.annetroy.com/mrexcel/Sample.xlsx
  24. Replies
    7
    Views
    120

    Re: Prefer Formula Solution to lookup value

    Sorry. I have about 8 employees who get advances. I'm not building a database for it. I have one, but I'm not doing payroll with it.

    I'm not sure how I would do this as a formula in multiple...
  25. Replies
    7
    Views
    120

    Prefer Formula Solution to lookup value

    Suppose I have these two columns, which are the employee and the amount they owe. In columns to the left (not shown below), I'm tracking payroll deductions/advances.

    John 600
    Judy 300
    John 500...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4