Dear all,
i have as per attached in A a series of successive numbers with empty cells under each.
I need to fill all empty cells (as in the yellow ones) so that cell in A will be copied down untill the number changes and so on..
thanks for any help
R
See:
http://dmcritchie.mvps.org/excel/fillempt.htm
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
can't get it to work
i think it is for an old version of excel
is there an easier way to create a formula in B to read down
thanks
Some variations on a theme. All checked in Windows XP with Excel 2007.
First is from Ozgrid, the others are from Dave McRitchie, credited to the authors. Module names have been changed slightly so that they are unique. You should be able to copy all of them to your workbook and test whichever you please.
Note that, in most of them, you need to select the cells before running the macro.
Please Login or Register to view this content.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks