Usedrange not updating

Function to get the First Used Cell in a sheet: '##################################################################### 'First Cell In Sheet : Function to Identify the First Cell in the used 'used range of a worksheet that contains data.

Thanks in anticipation John Run it to get the current used range, then put some more values in cells and run it again.

But with hundreds of rows of data, this will take forever. The number formatting of all the cells will update. What it does is take all the values from each row and then re-enters them into the cells automatically.

To speed things up, select the column and go to the Data ribbon and click Text to Columns. For this reason, this trick will not work for cells that are formulas.

There’s a quirk with Microsoft Excel 2010 (and possibly other versions) where custom number formats don’t get applied to existing data.

This quick fix can save you from the tedium of re-entering thousands of rows of data.