+ Reply to Thread
Results 1 to 5 of 5

How to select 4th cell down in current column?

  1. #1
    Registered User
    Join Date
    07-04-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    27

    How to select 4th cell down in current column?

    Hi,

    I am sure this is a really simple one, but my brain is not working!

    I have the following code. When I run the macro I want it to test the contents of the 4th cell down (row 4) in the active column, so basically replace the C with active column. Also in the body of the E-Mail set Range("C4") to the same.

    Can anyone help?

    TLP

    My Code:

    Sub AccClosureEMail()

    Dim OutApp As Object
    Dim OutMail As Object
    Dim strbody As String

    If Range("C4") = "Blah X" Then

    Set OutApp = CreateObject("Outlook.Application")
    Set OutMail = OutApp.CreateItem(0)

    strbody = "Dear " & Range("C4") & "," & vbNewLine & vbNewLine & _

  2. #2
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: How to select 4th cell down in current column?

    try this..

    Please Login or Register  to view this content.
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: How to select 4th cell down in current column?

    Another:

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    07-04-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: How to select 4th cell down in current column?

    Thanks John - that works perfectly!

  5. #5
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: How to select 4th cell down in current column?

    You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.


    9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Select Range of cells when rows are known, current column is not.
    By captbluefin in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-20-2012, 06:01 PM
  2. Replies: 4
    Last Post: 09-15-2012, 02:30 PM
  3. current cell - select 5 to the right
    By RxMiller in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-14-2010, 02:44 PM
  4. How to Select Current column
    By fastcart11 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-13-2009, 02:17 PM
  5. Want macro to select current cell
    By rdaugherty in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-13-2005, 12:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1