title: Can I use a =CELL("address" as a reference to define where VBA writes for me?
body: <p>I am trying to create a button on a worksheet which will input today's date in the first empty cell in a row which is designated by a drop down list.</p>
  
  <p>I have the dropdown set up.
  I have a column (C) which designates the address of the first empty cell in each row. C11 reads $J$11, C12 reads $K$12, C13 reads $J$13.
  I have a seperate cell (B2) that just references which input cell, based on what the dropdown list is currently set on.</p>
  
  <p>B1=employee name (Referencing the drop down on another sheet)</p>
  
  <p>B2=INDEX(C4:C100,MATCH($B$1,DatabaseTable[[#All],[Combined Name]],0)) (This finds the row, in this case, 12 and repeats the data in column C.)</p>
  
  <p>C12=CELL("address",INDEX(DatabaseTable[@],0,B12)) (This outputs the the next cell address to write in this row.)</p>
  
  <p>B12=MATCH(TRUE,INDEX(ISBLANK(DatabaseTable[@]),0),0) (This tells me which column contains the first blank in the row.)</p>
  
  <p>So, the specific question I have (unless someone can tell me a smarter way) is, how do I tell VBA to select the cell address from B2 (Which currently reads $k$12, but can change to anything, based on the drop down), and then write today's date in that cell? (I can figure out the writing part, just need to know how to select a cell based on the cell address output)</p>
  
  <p>Thanks in advance for any guidance anyone can offer!</p>