Auto filling with Macro

The UK's most regular instructor-led training courses.
Training information: excel training in uk · Excel courses · VBA training UK

Resolved · Low Priority · Version 2003

Auto filling with Macro

Nathan has attended:
Excel VBA course

by - delegate Nathan [1 post] (2008 Apr 29 Tue, 12:29) Reply

How am I able to autofill cells down to a certain point (cell) then continue the same process down with the new fill data?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 27 Thu	Bloomsbury	3	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	5	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
Full Schedule: See all 98 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Auto filling with Macro

by - trainer Alan silver contributer [73 posts] (2008 May 18 Sun, 16:53) Reply

Use the GOTO "Special" option then select Blanks. This will allow you to fill blank cells in the current range without worrying about AutoFill.

You can also use the selection options: select start cell, hold down Shift the press End key, release End key and keeping Shift key down press the Down arrow key.

· Identifying Suitable Candidates For VBA For Excel Training
· Basic Excel Training
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Advanced Excel Training - takes you to the next level
· An Introduction to Microsoft Excel: Top Features for the Excel Novice

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

Excel tip:

No Zeros

Want all the zeros in your worksheet to appear blank? Choose Tools/Options, Click on the View Tab, Deselect the Zero Values Option, Click OK.
Easy wasn't it? But be aware that these cells are not actually blank, they still contain the value zero. This is important because certain functions (ie AVERAGE) make a distinction between blank cells and those with a zero value.

View all Excel hints and tips