+ Reply to Thread
Results 1 to 3 of 3

Return Cell Address for Active/Selected Cell

  1. #1
    Registered User
    Join Date
    05-27-2014
    Posts
    2

    Return Cell Address for Active/Selected Cell

    I have a very very basic understanding of VBA, so having a ton of trouble executing with codes from other solutions.

    What I am looking for is the ability to return the address of a selected cell for use in either a) a forumal or b) in another cell

    So for example, ideal situation for me would be to have in cell A1, the value of a selected cell.

    I select cell B2, cell A1 would populate with the text "B2"

    I select cell AX145, cell A1 would populate with the text "AX145"


    Basically, my vba skills are so basic, I would need the full script to copy and paste...I'm not even really sure if this is a worksheet change or some other form.
    Please help! Anyone!

    Thank you

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Return Cell Address for Active/Selected Cell

    This method uses the Worksheet_SelectionChange event.

    Please Login or Register  to view this content.
    Target in this case is the selected cell(s)
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    05-27-2014
    Posts
    2

    Re: Return Cell Address for Active/Selected Cell

    crazy fast...amazing! THank you so much for the assist!

+ 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] Trying to change font in a frozen cell based on the address of the active cell. Possible?
    By sdavison in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2013, 01:23 AM
  2. Delete selected cell row vice active cell
    By leaning in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2011, 03:37 PM
  3. Change cell values based on Active Cell Address in Excel 2007 with no VBA
    By bdmistri in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-07-2009, 02:01 PM
  4. Delete rows where active cell is selected without hardcoding cell
    By alexfortin in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-19-2009, 06:58 PM
  5. Need VBA macro to return active cell address (R1C1)
    By Chuck Hague in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-02-2005, 04: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