Trouble exporting using Chip Pearson's export

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: dan dungan <stagerobber@xxxxxxxxx>
Date: Wed, 26 Sep 2007 22:15:47 -0000

Hi,

I'm using Excel 2000 running on Windows XP professional.

Private Sub cmdComplete_Click()
Worksheets("CompleteQuote").Range("A19:I19").End(xlDown).Select
DoTheExport
Clear_Unlocked2
Worksheets("CompleteQuote").Range("A19:G65536").ClearContents
txtCount = 0
Sheets("QuotedPart").Activate
End Sub

DoTheExport is Chip's code which works great if I manually make the
selection.

The range I want to select start on row 19 and can be of variable
length. Is there a way to select a variable range?

Thanks,

Dan Dungan

.

Follow-Ups:
- Re: Trouble exporting using Chip Pearson's export
  - From: Don Guillett

Prev by Date: Re: How can I remove leading zeros?
Next by Date: Re: How can I remove leading zeros?
Previous by thread: Web Queries
Next by thread: Re: Trouble exporting using Chip Pearson's export
Index(es):
- Date
- Thread