asked on Excel VBA 2010 - Determining row and Column sizes
My active cell is inside an island of cells somewhere on my worksheet and I would like to know:
1. how many rows and how many columns this region consists of
2. I'd like a message box saying "Your island consists of 9 rows by 10 columns"
How can I do this in VBA?
1. how many rows and how many columns this region consists of
2. I'd like a message box saying "Your island consists of 9 rows by 10 columns"
How can I do this in VBA?
Microsoft ExcelVisual Basic.NET
Last Comment
Faustulus
What do you mean by Island of cells. Is it a range that is selected (Highlighted) and the current cell is somewhere in the selected region?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.