title: Is there a way to reference if cells have decimal point in vba?
body: <p>I want to have create some code in VBA that will look through the cells in a worksheet in column B. If the code finds a cell value with a decimal (opposed to a whole number e.g. not 1, but 1.1) then print the cell value to right off it in another sheet. </p>
  
  <p>I know it will be a loop and it will use offset hit etc. I havent tried this code in VBA i have just typed it as an example of what i will do in the question. </p>
  
  <pre><code>For each cell in Sheets("Sub Tasks").Range("B1:B" &amp; LastRow)
       If cell = '(DECIMAL FORUMLA) Then 
  
  </code></pre>