Spaces in Data Ranges

The UK's most regular instructor-led training courses.
Training information: excel+training+best · Excel courses · VBA courses London UK

Resolved · Low Priority · Version 2003

Spaces in Data Ranges

Kate has attended:
Excel VBA course

by - delegate Kate [2 posts] (2008 Aug 14 Thu, 16:57) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Spaces in Data Ranges

by - delegate Laura [1 post] (2008 Sep 2 Tue, 18:07) Reply

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

Eg

Range("A1").CurrentRegion.Select

Laura

· Excel Macros for the Non-Programmer
· How Small Businesses Profit from Outside Excel Training
· Advanced Excel Training - takes you to the next level
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets

Please browse our web site to find out more about
excel+training+best and other Microsoft training courses.

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips