cellsr

I have stepped through the code below and it jumps from For r = 2 to total .........through to the bottom instance of ws4.activate I can't for the life of me workout why ? Any ideas ? 'Copy Super and Excpetional Clients who are yet to travel to Tab 3 ws1.Activate For r = 2 To total...

Hello, i'm completely new to VBA I receive the following error 1004 Application-defined or object-defined error. the following code is processing this error. What needs to be accomplished is that assumes that he is 100% minus the value in the previous cell is value in cell a b c d 50...

Hi, I am trying to create a userform that looks up an address on Google Maps, or directions between two addresses. I got the above error message when creating this code below: Private Sub CommandButton1_Click() Dim r As Integer, r2 As Integer, URL As String Application.ScreenUpdating = False...

Hi, I have created the below script to send the n number of auto emails by clicking command button. However I could not insert the hyperlink from cell value. SCRIPT: Sub Button1_Click() Dim o1App As Outlook.Application Dim o1Mail As MailItem For r = 2 To 11 Set o1App =...

I am getting a Compile error on the red line: Expected Function or variable. Sub age() RC = Cells(Rows.Count, "G").End(xlUp).Row + 12 'Start on row 12 For r = 1 To RC d = Cells(r, "G").Text sd = Mid(d, 7, 2) & "/" & Mid(d, 5, 2) & "/" & Left(d, 4) age = Cells(8, "J") - CDate(sd)...