Excel - Delete unused cells

[BobJacksonNCI]

I've already been assisted with most of my automation project, but ...

When I "Save As" to create a tab-delimited text file to be imported into G/L, the end of the file is often after the last actual data. That causes a problem with the G/L program when imported, so now I have to manually delete the excess, visually blank data.

Is there a way to automatically get rid of it?

Background at: thread68-1223260

I am positioning at the last active cell - and, as I said, it's often blank. Right now it's easier to edit the resulting text file than to tinker in Excel.

As always, thanks in advance for your assistance.

If my description is not clear, please post.

Bob

 

[SkipVought]

Hi,

As long as there is no formatting or residual data, (residual data can include formatting and cleared contents instead of rows/columns deleted with a shift of some kind) only the rows of data is exported.

Select ALL unused rows and DELETE Shift Up

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}