Excel VBA formulas for Spreadsheet by Sharath Kumar Peechara - HTML preview

Exercise 23: Rowheight() function

To create this Function, execute the following steps

1. Create a UDF Rowheight() ( User Defined Function)

1. Open Excel VBA (Alt + F11)
2. Insert a New Module
3. In the Project Explorer, double click on the Module
4. Add the following code line:

This Code lines will create function Rowheight()

In Cell B1 Type

= Rowheight(A1)

In Excel Sheet

click on Home Cells Format Row height to know the size of the Column