I am trying to delete the used range of an excel sheet.
The range still displays a count like 134 whereas ideally shouldnt it be 0?
How can a used range / used cell be eliminated completely before new data is copied into the same?
I am in the process of copy pasting contents from oneworksheet to another worksheet in a different workbook
I got the issue, its working fine now. Thanks a lot. Yes the used range comes to 1 after that, i am using 2007
I guess i had accidentally selected some cell previously responsible for showing the incorrect used range and borders were getting applied on blank cells
Its working fine now
Thanks a lot
Is there a way to wraptext only a specific cell in excel.
I tried applying the WrapText on the entire used range but it distorts the row height for the other cells as well which makes the excel formatting look real ugly.
This is what i want.
Find position of cell "A" in excel and wrap text the cell next to it only (which is in next column)
I want to wrap only the XXXXXXXXX part which would change the row height only for this row keeping the other rows and column heights as it is
Additionally i am trying to copy a well formatted excel sheet into shared drive and i want it to be copied as it is using the following code:
(this is well formatted with borders and all)
objWorkbook2.Worksheets("PX").Range("A1").PasteSpe cial Paste =xlValues
This is distorting the excelworkbook2 excel.autofit applied on workbook1 is all completely lost.
Is ther a way to copy paste the used range contents as is so i dnt have to make any further changes in workbook 2
Additionally we can apply text wrapping to specific cells in excel:
row = "B"& objCell.Row
Set objSWATRange = objWorksheet.Range(row)
objSWATRange.WrapText = True
Set objCell = Nothing