[vba] How to get the size of a range in Excel

Using VBA, is it possible to get the size of a given range in terms of pixels or units? (I don't care which unit as I am only using it to relate to other measurements with the same unit).

Thanks.

This question is related to vba excel size range

The answer is

The overall dimensions of a range are in its Width and Height properties.

Dim r As Range
Set r = ActiveSheet.Range("A4:H12")

Debug.Print r.Width
Debug.Print r.Height

The Range object has both width and height properties, which are measured in points.

Source: Stackoverflow.com

Examples related to vba

• Copy filtered data to another sheet using VBA • Better way to find last used row • Check if a value is in an array or not with Excel VBA • Creating an Array from a Range in VBA • Excel: macro to export worksheet as CSV file without leaving my current Excel sheet • VBA: Convert Text to Number • What's the difference between "end" and "exit sub" in VBA? • Rename Excel Sheet with VBA Macro • Extract Data from PDF and Add to Worksheet • Quicker way to get all unique values of a column in VBA?

Examples related to excel

• Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support • Converting unix time into date-time via excel • How to increment a letter N times per iteration and store in an array? • 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data) • How to import an Excel file into SQL Server? • Copy filtered data to another sheet using VBA • Better way to find last used row • Could pandas use column as index? • Check if a value is in an array or not with Excel VBA • How to sort dates from Oldest to Newest in Excel?

Examples related to size

• PySpark 2.0 The size or shape of a DataFrame • How to set label size in Bootstrap • How to create a DataFrame of random integers with Pandas? • How to split large text file in windows? • How can I get the size of an std::vector as an int? • How to load specific image from assets with Swift • How to find integer array size in java • Fit website background image to screen size • How to set text size in a button in html • How to change font size in html?

Examples related to range

• How does String substring work in Swift • Creating an Array from a Range in VBA • How to create range in Swift? • Why is "1000000000000000 in range(1000000000000001)" so fast in Python 3? • How to find integer array size in java • How does one make random number between range for arc4random_uniform()? • Skip over a value in the range function in python • Excel Define a range based on a cell value • How can I generate a random number in a certain range? • Subscript out of range error in this Excel VBA script