wrong positioning of data in sheet after clearcontents()

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey eb
I am clearing the contents of one sheet using clearcontents().

Then transferring new data to that sheet using dts (data transformation task).

Unfortunatly that data is positioned in the sheet, below the range i had
cleared befor,instead of replacing the empty rows there.

Any idea why??

TIA
Rea
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

after clearcontents() new data is positioned below the cleared ran 5
Want code to copy to ABOVE row 22 column A on sheet 1 10
ClearContents 2
Loop thru some sheets in wkbk and call macro - better way? 2
clear contents of cell 3
Copy Array to Array, how to and should I? 13
Clearing the contents of a row 2
Compating all rows in two sheets 2

Back
Top