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?
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:
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
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")...
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...
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?
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...
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:
Dim outlookApp As...
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)...
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...
I am facing an issue with an email macro. Specifically, I used the one from this website:
However, when I run the code, it says the following:
Can somebody please help me fix this issue?
I'm having a couple issues with formulas which i'm not smart enough to solve, I hope someone will be able to help me, I've added the minisheet at the end of this wall of text K to N is filled manually.
Q displays error "VALUE" if K or M is N/A, Q should remain blank in this case...
I've got this formula but keep getting a run time error (Application-defined or object-defined error). I've read about the error a few times but I don't understand what's causing the problem.
It's just a checkbox and I want to replace the formula used based on the status of the checkbox...
I'm trying to split up an Excel in several excels based on a list of values in another Excel.
Let's show an example:
You see that in the top left Excel there is a list of values. My script starts with the first value 'binnendeuren' and search that value in the first 3 columns of the...