messages

  1. B

    What chart/timeline to use to organise my messages

    Hello I have a lot of messages (300 approx) between myself and my bank that span a 1-2 year period. I want to enter all these messages into some sort of timeline, chart. That starts from the first message and progresses thru to the last message. I guess some sort of excel flowchart, or message...
  2. E

    Is this a bug?

    Hello When I try to copy a sheet I get the following error, which no matter what I click, does not go away (it actually generates tons of such messages with different name) i.ibb.co/BwffP3p/Capture.png Any idea please?
  3. mikecox39

    Mixed messages

    I know that [=NOW ()] delivers the current date and time; depending on how the cell is formatted, but that function is dynamic and, if left in the cell, changes over time. I read somewhere that you can copy the result of that formula the paste it back, as data, to convert it to as static...
  4. T

    Adding Screen prints to messages

    Using Microsoft Snip & Sketch to capture current screen print, I can not figure out how to "copy" from that application to post to my messages here. I was told to select the insert image from the ribbon, but it is prompting for a URL instead of .pdf file location. In other applications, I can...
  5. A

    Count and Countif

    I thought count and Countif could use cell references to count how many results were in a particular column or row. example =count(A8,a10,a,11,a15,a22"W"). I have tried the example with count and countif and keep getting error messages. Can anyone assist? Thanks Allie
  6. D

    Troubleshooting VBA for Disabling All Input Messages in a Workbook

    I have VBA that works quickly for disabling all the input messages on a single worksheet but when trying to generate a macro that will run it on all worksheets in the workbook I get an error on the "c.Validation.ShowInput = True" line after it finishes the first worksheet. Would appreciate any...
  7. G

    Novice user needs elementary help with cut and paste operations

    I am repeatedly finding that efforts to cut and then paste are being thwarted with the appearance of one or another error alert messages. I will describe these messages because it appears I cannot attach images of them to this message: The first states "That command cannot be used on multiple...
  8. K

    Error in VBA formula

    I cannot get this line of code to run aDataCalcs(r, 19) = Sheets(DataCalcsnew).Range("T3").Value & " - " & Sheets(DataCalcsnew).Range("Z3").Value I am not seeing any error messages in the vba editor. What can I do to fix this?
  9. C

    Identifying Duplicate Values

    Hi MrExcel, I'm working with a large data dump (>3000 rows) that contains multiple columns but only two values that I'm primarily interested in: messages and message codes. Every message has a code and every code has a message, and what is supposed to be true is that every code has exactly one...
  10. gheyman

    Enter Numeric Values only

    Is there a way to limit what a user can enter into a cell. I need for them to only enter number. Even with comments and data validation input messages I still get users entering text. Some people enter things like "100.5 hrs." instead of "100.5"
  11. C

    How avoid "MS Excel can't access the file" messages upon opening workbook? Infinite loop

    I have an existing workbook that has some links in it. These are links that I did not intend to have. When I open the workbook I keep getting the message "MS Excel cannot access the file "http://.... .. ". Please make sure you are using the correct address. The problem is that I'm in an...
  12. K

    Strange message about pm storage

    I tried to send a pm to a member here. ut when I submit send I get this wweird message: "You have reached your stored private message quota and cannot send any further messages until space has been created." I'm new here. How can I have "stored" pms if I never sent any?
  13. K

    Pms are not working correctly

    Was notified that I received a pm from a member. But I cant open it. Its like theres no messages there. Anyone can help?
  14. L

    VBA outlook outbox delete messages

    Is there a way to delete in outlook 2010 outbox all messages without attachment?
  15. JenniferMurphy

    Is there a way to limit MsgBox messages?

    I'm doing a little re-engineering of my personal add-in module. I am making changes to several functions. Some of these are incompatible with way the function used to work. I don't know where all of the function calls are (which workbooks and sheets), so I am putting MsgBox calls to tell the...
  16. G

    Screenshots of Excel Spreadsheet in message

    I noticed in looking at some of the posts, some participants are able to add screenshots of Excel spreadsheets in posted messages. Could someone explain how this is done?
  17. R

    Averageifs

    I'm using an AVERAGEIFS function [=AVERAGEIFS($F$4:$F$24,$L$4:$L$24,I2,$D$4:$E$24,H2)] that is looking at both a date and time to do the average. I keep getting an error messages in relationship to the time portion of the function. Is time usually more quirky with an AVERAGEIFS function? Thanks
  18. C

    Disable Alert Messages

    - I have various alert messages programmed for textboxes on a userform Question - I do not want any alert messages to display upon clicking the red x on the top right of the userform Thanks OJ
  19. S

    Calculating back until certain sum is reached

    Hi all, First time here, not sure if this is a simple problem that I just can't figure out how to solve. For those familiar with the messaging platform Slack, I am trying to forecast/estimate as my organisation uses the platform, how far back our 10,000 message searcg limit will serve us. For...
  20. B

    Features on daily attendance sheets

    Hi, I was wondering if there is something that could be put in an excel sheet, probably an event code macro I think they are called, that could give a pop-up message right before someone exits out of the file, basically giving them reminders of things to do before they close the file. If someone...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top