row_number

Hi All, I am getting an "Excel Cannot Complete this Task with Available Resources" message when I attempt to run the below macro. The issue only occurs if I paste 1 line of data in the macro workbook If I have more than 1 line, everything runs as I expect. In my code below, is my If...

Hello- I have this code that I was able to string together that would email from Excel using Outlook. Honestly, it is barely doing what I would like it to do. What i'm trying to do, I'm sure is very simple for you guys. I have a distribution list with many rows. Basic name with email address. I...

I have a macro that I used to send emails. Everything is working but I wanted to add a Start time and end time to the email. The problem that I’m having is the time is showing up as a number and not a time in the email. Example = .5 to 12:00 pm. How do I change the format to a text time...

Hello all, I am trying to finally get my first user form working and hoping its quite basic for asking for help I would appreciate any help trying to glue the final pieces together and helping with a couple of issues. I have the form made and its working so far but need help code to get it fully...

Hello All! Please forgive my complete lack of inexperience. I have never taken a class on writing excel macros and have so far been able to piece through what I have needed to do by intensive google searching, but I can not seem to get this code to work. When I hit play it doesn't actually give...

Hello, I have a userform with one textbox that does a vlookup. I have the following code which works when clicking on the box. Is there any way to have this shown when tabbing, or automatically after textbox1 info is entered? Private Sub UserForm_click() Do DoEvents row_number = row_number + 1...

Hi All I have code which I have used in many projects that always worked and returned the desired results. I am presently producing another spread sheet and the VBA for retrieving data from a sheet to the userform based on a specific criteria is not working. I tried the back up code but this...

Good morning all, I have a code that I am using to enable a UserForm to display info about employees. The user is then able to amend the data and the spreadsheet updates. I've got a search function working but I want the user to be able to search with one option OR the other option not a...