title: Excel 2010 select each cell in a row, activate them one by one
body: <p>I have an XML file that I drop into Excel to make it automatically generate a table. First column(A) has a name, and the second column(B) has a date. There are a few more columns, but those are not relevant to this question.</p>
  
  <p>So it looks like this screenshot:</p>
  
  <p><img src="https://i.stack.imgur.com/t1ScN.png" alt="Screenshot"></p>
  
  <p>Now there is a very idiotic bug in Excel (2010). When I have the Data column, I set its property to be Dates. But Excel does not understand they are dates now. But if I double click in a cell to activate it, at that point it starts to understand its a date... strange bug, but I have to to this for each cell.</p>
  
  <p>Now what I was thinking, is to have some macro or something, that activates each cell (if there is content) one after another in the B column.</p>
  
  <p>Now, I don't have a clue how I can do this in the build in VBA of Excel.</p>
  
  <p>Is there someone out here that could help me? I can imagine it would only need a handful of lines to make it work.</p>