PDA

View Full Version : [SOLVED] Range and Selection question



JKwan
12-09-2004, 08:36 AM
How do I find out how many Columns and Rows in a Selection (the dimension of that Range) in VBA?

Thanks

Jacob Hilderbrand
12-09-2004, 08:49 AM
Selection.Rows.Count
Selection.Columns.Count

Jacob Hilderbrand
12-09-2004, 08:51 AM
Also if you want to know the first row/column:


Selection(1, 1).Row
Selection(1, 1).Column