Tiffany Notes Letter “s Round Pendant

View cell comments

post in this show a couple of ways to work to see the formulas in an Excel file. First we will see how to display formulas instead of results in general and then show the formulas and comments from those cells that they contain these, for it will employ some VBA routines.

1. See formulas instead of values \u200b\u200b

To see formulas instead of values, we must activate the formulas, for this in Excel 2007 in the Formula list, click on Show Formulas as shown in the figure below.

Then the cells will be as follows:

2. See formulas and cell comments

For this we will use the property HasFormula with the cells, but before that will determine the row and column farthest to set the range to search HasFormula. This is determined by the following function:



lines 4 and 5 determine the last rows and columns with content. You can = UltimaCelda () in any cell to see the result.

Then from the range A1: UltimaCelda seeks those cells with formulas and the formulas become the comments. This is accomplished with this code:

In line 6 checked against HasFormula property if the cell has formula, if which adds as a comment to AddComment method. Excel file with these codes you can download it here .