Deleting Blank rows after Data-TJ

A

ambushsinger

does anyone know how to delete the blank rows that occur after data insertion
into a worksheet?

TJ
 
L

Linq Adams via AccessMonster.com

If by "worksheet" you mean a Datasheet form, this is the default behavior.
You'd have to make the form read-only, arrange for the user to turn on
AllowAdditions and AllowEdits, then turn it back off after the new record was
saved. Since Datasheet forms cannot display command buttons, turning these on
would have to involve something like Double-clicking a field. All in all, a
lot of work in order to make a Datasheet form not perform as most people
expect them to.
 
A

ambushsinger

Thank you but I'm referring to a sheet in an Excel workbook that has been
populated with data from an access query.
Once this data has been copied from the query into a spreadsheet there are
alot of empty rows. I'd like to know if there's a programatic way to delete
them.
 
Top