coding error

Hi, I have a VBA spreadsheet but it seems to have become corrupted over the years and now gives a run-error and doesn't compete the calculations. I admit my VBA knowledge is lacking and I cant find where the mistake has occurred. Can anyone help? How do I add the file with the code?

Hello everybody, I am currently having a problem with one of my files. I have made an order form where people can order goods from. They download my excel sheet and click on a submit macro which sends out the excel sheet in a PDF file through email. This works perfectly fine when I do it...

Hello everybody, I am currently sitting with the following material overview file in Excel: I have made some conditional formatting so whenever I enter a number in column E the entire row gets highlighted. Unfortunately, this erases/makes invisible my dark gridlines/borders from before...

Hello, I'm quite new at this, so please forgive any lack of knowledge. I'm trying to get a macro to search for a term in a column (in this case, Camacho Services and column D) and when found, copy the row that has that data to another sheet. As I am a newbie, I modified the code from...

I cant figure out whats wrong with my coding. I get an error message every time the code reaches the Bold Red txt shown below, If any of you can see something that i am not catching please let me know. The error message states "1004" Run Time Error, Application-defined Object-defined Error...

Hi there Excel Wizards, I wonder if you can help me with a problem I'm having. I'm creating a heat map in Excel, and after many months of struggle I've managed to source the code. When I've put it together in VBA (of which my knowledge is zero), I get a Procedure Too Large message. I've...

This coding verifies if an Email Is Correct, where is the Next without a For, or coding error? Function IsEmailValid(strEmail As String) As Boolean Dim strArray As Variant Dim strItem As Variant Dim i As Long Dim c As String blnIsItValid = True i = Len(strEmail) -...

Hey guys, when I try to run macro, it is giving me error 9. Please help!!! Here is my coding, and I cannot figure out what is wrong with it. Sub HR_Amazon() Dim sVariable As String Dim vEntry As Variant Dim iCounter As Integer Dim iCounter2 As Integer Dim iCounter3 As...