+ Reply to Thread
Results 1 to 10 of 10

Get row and column header of active cell

  1. #1
    Forum Contributor
    Join Date
    11-20-2011
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007, Excel 2003, Excel 2010
    Posts
    284

    Get row and column header of active cell

    Im trying to get the row name in cell k1 and the col name in cel k2 of a table when the active cell is selected. Any thoughts? Thanks.

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Get row and column header of active cell

    not completely sure what your after but it sounds like

    ActiveCell.Column
    Activecell.row
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Contributor
    Join Date
    11-20-2011
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007, Excel 2003, Excel 2010
    Posts
    284

    Re: Get row and column header of active cell

    That is where I started already but to take it a step further I am trying to get the column and row header names using active cell row and column.

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Get row and column header of active cell

    what do you mean by header name?
    like ABCDEFG?

  5. #5
    Forum Contributor
    Join Date
    11-20-2011
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007, Excel 2003, Excel 2010
    Posts
    284

    Re: Get row and column header of active cell

    That would be the columns and row header of the active cell. So for columns it would be row 1 and for rows it would be col 1 values of the active cell

  6. #6
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Get row and column header of active cell

    like this?
    Please Login or Register  to view this content.

    or the value of row one in the column?

    like
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Last edited by humdingaling; 03-26-2015 at 09:37 PM.

  7. #7
    Forum Contributor
    Join Date
    11-20-2011
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007, Excel 2003, Excel 2010
    Posts
    284

    Re: Get row and column header of active cell

    That worked for the col but not yet for the row. The row should pull the value in col 1 for active cell

  8. #8
    Forum Contributor
    Join Date
    11-20-2011
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007, Excel 2003, Excel 2010
    Posts
    284

    Re: Get row and column header of active cell

    Cells(active cell.row,1).value worked for the row. How can I run the macro when active cell is changed

  9. #9
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Get row and column header of active cell

    sorry dont know what you mean now
    activecell is the cell that is active at the time you run the macro or if your code points to as activecell

  10. #10
    Forum Contributor
    Join Date
    11-20-2011
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007, Excel 2003, Excel 2010
    Posts
    284

    Re: Get row and column header of active cell

    Iv already solved it with the solution I need. Thanks for the input

+ 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. Problems with autofilling formula down the active column to the end row using active cell
    By sl_riches2179 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-27-2013, 09:30 AM
  2. row header from active cell
    By Scrungie in forum Excel General
    Replies: 3
    Last Post: 03-27-2007, 03:23 PM
  3. Excel 2003 color of active row and column header
    By ydenne in forum Excel General
    Replies: 2
    Last Post: 05-15-2006, 01:15 PM
  4. How to set highlight for the column&row header of the active cell
    By Jasmine in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-14-2006, 11:40 AM
  5. Active row and column header color
    By Tony G in forum Excel General
    Replies: 5
    Last Post: 05-23-2005, 04:06 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