Excel VBA - read cell value from code

Question

task to send email from excel  Below is the example column  How I can get the email value from the loop  Thanks    Here is my code        Dim rng As Range    Dim row As Range    Dim cell As Range    Dim mydate As Date    Dim myDiff As Long  Set rng   Range  E5 E17   Set rng2   Range  F5 F17   Dim cell2 As Range  Dim i As Integer i   5  For Each row In rng Rows   For Each cell In row Cells  MsgBox cell Value mydate   cell Value myDiff   DateDiff  d   Date  mydate   Set rng2   Range  F   amp  i  For Each cell2 In rng2  MsgBox cell2 Value Next cell2   If myDiff   -8 And myDiff  lt  8 Then   aEmail Send End If  i   i   1   Next cell Next row

User · Accepted Answer

I think you need this     Dim n as Integer     For n   5 to 17   msgbox cells n 3   -- gt  sched waste   msgbox cells n 4   -- gt  type of treatm   msgbox format cells n 5   dd MM yyyy    -- gt  Lic exp   msgbox cells n 6   -- gt  email col Next

[excel] Excel VBA - read cell value from code

Examples related to excel

Examples related to vba