title: VBA user-defined function to copy value, text formation and hyperlink of a cell?
body: <p>Given a sample plain excel file <a href="https://dl.dropboxusercontent.com/u/6194904/2013/copy%20excel%20cell%20value%20and%20formation.xlsx" rel="nofollow noreferrer">here</a>, what is the VBA code to copy value, formation and hyperlink of a cell? </p>
  
  <p>i.e. At cell B5 we will call <code>=myCopyCellFunction(B2)</code> and we will get the exact cell value at B2</p>
  
  <p><img src="https://i.stack.imgur.com/Ej27s.png" alt="enter image description here"></p>