error

Hey All, I'm getting the error that no cells have been found when running the following code. Although it is correct and no cells have been found under the criteria I've put, I want the code to just move on and continue with the code. Could anyone help me to do this? I am a beginner when it...

Hi This has flummoxed me. I have attached two images showing how the address details are displayed in the cells, and how they are displayed in the drop down preview section. As you can see there is the odd square symbol representing a line break in the main cell section and the line break in...

I’m getting this error to populate my worksheet from another software provided by my company. Can you help me solve this?

Hi All, Got another issue but this time pertaining to an Expression Error which I cant quite figure out. The workbook that I'm working on is connected to Dynamics 365 where a separate tab showing all the data has been created. I have built the data entry and and pivots around the fields that...

I have a table with several columns as shown below. The issue is that I must do a search for a number entered manually. The search must be done in a column that results from multiplying the value $ by 100. With some values, inexplicably, the result of the formula +MATCH(I;$H$4:$H $164;0 ) is...

Interesting one for you all - Excel 365. If I use a simple formula to subtract 1-1 I get, as you would expect a 0 (Row 2) However, if I nest this inside an iferror formula I get a very strange answer (yellow cell). (Row 3) Anyone any thoughts on why this is happening?

Hi all, I currently have a macro that saves my sheet as a PDF, however when I try to do this, it brings me this error: If I debug it highlights this in my VBA code: The code is this: Option Explicit Sub SaveFileWithMacro() Dim Path As String Dim fn As String Path = "R:Path\PDF files\"...

I have a workbook with two sheets. On the "Likes" sheet, I have a list of URLs (and other things that are not relevant here). The second sheet, "Apr-4.13.22", has topic titles and their URLs. I want to pull the topic titles from "Apr-4.13.22" into the "Likes" sheet. The formula I attempted to...

This is my full code Sub StripData() Call InsertData Call FormatData 'Call DragData End Sub Sub InsertData() Dim myWb As Workbook Dim myRowsToCopy As Range Set wbtemplate = Workbooks("Template.xlsm").Worksheets("Raw") Set formatrange = Range("B2:CE2") Set formularange = Range("AK2:CE2")...

Greetings, I have a macro workbook that was created in Excel 2016, however VBA was added to it in Excel 365. It works fine when opened using MS 365 however the users that will need the from/wb have 2016. When opened in 2016 I am receiving a !VALUE error in the cells that should be calculating...

I need big-time help here! I have altered the formula so many times and have gotten completely confused and still, get an error "The function in the formula causes the result to change each time the spreadsheet is calculated. The final evaluation step will match the result in the cell, but the...

Hi all, Why do I get this error? When I run my code, it should send out an email. Thank you Kind regards, Jyggalag

I have a table with 20 rows and only 6 rows have data in them. I'm trying to get the average of only the rows containing data in a column. Can anyone help me figure out why I'm getting an error on this formula? Example: Sam 5 Jess 2 Dean 4 Michael 4

Hi. I have a sheet that multiple people will work in to update a worklist. I've got around the issue of updates being 'posted' to a hidden sheet overwriting the same line if two people do it at the same, but I'm also getting it to save as part of the update code, so it's immediately available...

So I have been having this same problem for a long time. I just work around it, by scrolling with my mouse, which can be tedious. We used to have MS 2016, now we have Office 365. Problem existed on both. The document is a shared document, old school, not the internet sharing because I need to be...

Hi there, I wrote a script that connects to SAP and executes different tasks. A lot of the code is related to various SAP transactions, fields and functions, so the code won’t make much sense or be particularly useful. However, I will share the code that is giving me trouble and do my best to...

Hi all (please scroll to the bottom for the question), I am currently trying to use the following code to send out word documents through a vba macro (source: Using Excel VBA to Send Emails with Attachments - wellsr.com): In code format: Sub AttachMultipleFilesToEmail() Dim outlookApp As...

Dear all, I am trying to run a macro that sends out emails, however when I try to run it I keep getting this error unfortunately: Can somebody please help me figure out why? I have tried setting source = ThisWorkbook.FullName (takes the current excel file I am typing in as an attachment)...

Hi All, I am having an issue in Excel. My current setup looks like this: However, if I put range("O2") it works fine and it sends out the email to my email address. But once I try to increase the range and make it send out to multiple emails, it comes with the following error (highlighting...

Hi all, I am facing an issue with an email macro. Specifically, I used the one from this website: https://www.wallstreetmojo.com/vba-send-email-from-excel/ However, when I run the code, it says the following: Can somebody please help me fix this issue? Thank you! Kind regards, Jyggalag