mess

I am getting a compile error: Syntax error on this line, but can't figure out what the problem is. I am obviously new to this. Mess = Replace(Replace(Mess, "#FirstName#", FirstName), "#team#", Team), "#gamedate#", gameDate), "#location#",Location), "#gametime#",Time"), "#field#",Field))...

Hello, Is there another way of using the user form and still be able to edit the excel sheet besides the userform1.show false ? I get an error when I use that on my code. when I add the False statment it will mess up where the userform data needs to be saved. thisworkbook code is this: Private...

I have been using Smart Indenter for years and have recently upgraded to excel 2016. can't use it any longer. I see that there is a possible work around involving deleting and reinstalling the MSADDNDR.DLL file. What will that actually do to my computer? what is the difference between that file...

Hello All, I have taken over a workbook and it looks absolutely messy. I need to be able to delete rows from the summary sheet of the workbook, without compromising the data on the other sheets. How can I do this?

i am using the below code to open and email and add the recipient based off cell values. I have been working all day to try to find a way to open 7 of the same emails but have them addressed to different people with one macro. any tips? thanks in advance! Sub Rectangle1_Click() Sub Mail()...