Spaces in Data Ranges

Resolved · Low Priority · Version 2003

Thu 14 Aug 2008, 16:57 Delegate Kate said...

Kate has attended:
Excel VBA Intro Intermediate course

Spaces in Data Ranges

How do you code a macro to select a data range including spaces ???

Tue 2 Sep 2008, 18:07 Delegate Laura said...

RE: Spaces in Data Ranges

If your data doesn't include rows or columns that are completly blank you can use "currentregion"

Eg

Range("A1").CurrentRegion.Select

Laura

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips