ANmAddress_Dimensions

Detects how many dimensions an address has,
This is what I call it dimensions inside excel 1-Dim, 2-Dim, 3-Dim, 4-Dim and 5-Dim
Returns 0 if address is 1 cell
1 if address is within 1 row or 1 col
2 if address has multiple rows and columns
3 if there was a sheet reference
4 if workbook ref was found
5 if workbook is in a different folder

If ReturnDimensions012Only is passed as 1, then will return only the dimensions 0, 1 or 2 even if address has sheet or workbook in ref
If 0 (default) it will check address for sheet and workbook and return accordingly
Once sheet is found, 3-Dim is returned even if it was only 1 cell
Same to workbook or folder

CodeFunctionName What is this?

Public

Not Tested

Original Work

Access is limited.

Login here using your Linkedin account. to see or download code.

No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Mydev.net

Linkedin Login

OfAddress, Optional ReturnDimensions012Only = 0

Views 2

Downloads 0

CodeID
DB ID