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
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