cellscell.row

hello , i use the following email template :- Option Explicit Sub PC_Email() Dim OutApp As Object Dim OutMail As Object Dim strbody As String Dim MailAttachments As String Dim cell As Variant ' Not previously DIM'd...

Hi, apologies Im a little new to this but I have a spreadsheet that is intended to automatically send an email based on the result of a formula. The code I have in ThisWorksheet for sending the email is: Sub Test1() Dim OutApp As Object Dim OutMail As Object Dim cell As Range...

Hi, I am new on the form and not very familiar with Macro's. I found the following macro on the web. Sub SendEmailfromOutlook() Dim OutApp As Object Dim OutMail As Object Dim cell As Range Dim Path As String Path = Application.ActiveWorkbook.Path Set OutApp =...

Hi, I am experiencing some strange issues using my macro for excel, I'm no professional coder but it reads like it should work okay. In fact it does work on the first cell and then the results are strange. I have a macro that when run on particular cell will color the surrounding cells green...

I am trying to do the following, here's some images explaining it: 2: 3: The WO# never changes and never repeats. There can be 1,000s of w.o. numbers and I avoid defining definitive ranges in VBA because data is constantly added and deleted. To help solve this problem, I used this formula...

Hello, I use the below VBA code to generate working hours. I need it to subtract 1 hour from the total? Any thoughts? Public Sub Worksheet_Change(ByVal Target As Range) Dim Cell As Range ' Calculate working hours if start and finish are both present For Each Cell In Target...

Hi, I have a macro that attaches a sheet, but this month I need to have 2 attachments in the email. For some reason I can't get my macro updated to do this. sample data and current macro below. In column C I've separated the the files to be sent with ; Data- Column A - <tbody> Surname, Name...

I am working on a spreadsheet that will send emails and their attachments to any vendor that has a "yes" in row H. The file path/name of the attachment is stored in row G. I can get it to work if I just do one at a time, but once I try to use a loop to generate all emails and attachments at...