| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
wrong positioning of data in sheet after clearcontents()
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
wrong positioning of data in sheet after clearcontents()
Read my reply to your earlier post.
Mike F "Rea" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help positioning data labels | Charts and Charting in Excel | |||
| Hyperlink in same sheet - positioning problem | Links and Linking in Excel | |||
| after clearcontents() new data is positioned below the cleared ran | Excel Programming | |||
| Recalculate sheet & Positioning text boxes | Excel Programming | |||
| Positioning Data / Form dialogue box | Excel Programming | |||
Hybrid Mode
