#runtimeerror1004

Hello mates!, hope you´re fine I have a trouble with my excel macro due to Mail.Evelope doesn't have font size proprieties, and someone on the forum suggest me to put the message that I want to send in a cell and after that change the font size of these cell where I put the message but when I...

I need help creating a macro that goes through each file in a folder and copies distinct cells in each file (all the files have the same formatting). Then I need to paste each cell into a master sheet that contains merged cells that are different sizes (as shown in the picture attached). With...

I am trying to create a button that will filter a table and delete row entries that are more than two days a head (i.e. today is Monday and I want to delete rows that have a date past the coming Wednesday). The date column is in column A and I have D2 is "=Today()" I am getting the "Run-Time...

Hi Everyone, could someone please assist me. Following code: Option Explicit Public sTimer As Boolean Public sTimer2 As Boolean Public sTimer3 As Boolean Public sTimer4 As Boolean Public sTimer5 As Boolean Public sTimer6 As Boolean Public sTimer7 As Boolean Public sTimer8 As Boolean Public...

Hello, I have the following code which copies a master worksheet with formulas and renames it with the company code and cost center. Everything is happening in the same file, which is a database with cost centers and companies to be charged out. Each time a new cost center is added to the list...

Hi, a run time error 1004 occurs whenever the macro has finished looping through sheet names which contains "Country Financials". Your help please on what workaround should I do to prevent the error and continue to save the workbook. Thank you in advance for your help! Sub FormatFiles() Dim ws...