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?
ChloesDad
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.