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.
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.
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.
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.
what do you mean by header name?
like ABCDEFG?
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
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.
That worked for the col but not yet for the row. The row should pull the value in col 1 for active cell
Cells(active cell.row,1).value worked for the row. How can I run the macro when active cell is changed
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
Iv already solved it with the solution I need. Thanks for the input
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks