1. W

    Emailing Attachments

    Currently i am manually updating my email code evertyime I cahnge the attached files I am needing to send. So i was wondering, hoc can i attache all files in a folder automatically to an email? Line 1 is an example of teh attachement code, lin two is what ai was thinkiong of but does not...
  2. E

    Pasting Values

    Hi all, I am having an issue with my macro. I have a button set up to copy data from one sheet and then paste it on another. A formula in one of the cells is pasting and changes when it gets paste, thus throwing a Ref error. I want to keep both the formatting and the value, so...
  3. C

    Chart Popup

    When user holds cursor over chart and editing pop up appears to teh right of chart. How do I turn that off? As always, your help is greatly appreciated.
  4. F

    Linking a date in an excel cell to outlook calendar

    I would like to be able to enter a date in a particular column in my worksheet, and have it put a follow up task in my outlook calendar. It would be good if the action collected teh customer name from any cell, and included it in teh reminder/appointment. Is this possible, and if so how?
  5. Trevor3007


    Hi I currently use =IF(A2>0,NOW()), which is great when A2 meets the criteria, however when A2 does not meet the criteria, A2 displays False. I would prefer that A2 was just blank if the criteria is not met rather than display False. Does any know/have the solution ? MTIA & KR Trevor3007
  6. W

    getting sheet/table name

    I know how to get the name of teh active sheet but is it possible to get the name of the table ?
  7. T

    Validate User form text box

    The code below checks for the value entered into the textbox. Private Sub Date_Change() If Not IsDate(Date.Value) Then MsgBox "Must be a date" End If End Sub The problem is whenever the user attempts to enter a date, such as 01/01/2018, as soon as 0 is...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...