I have a large data sets, for each one the first 500 rows are just noise. At the moment, I am deleting them manually, but if anyone can help me to write a script, that would be much appreciated.
Hi Fanning, I wrote a simple code below which might serve your purpose:
doc -ef W {
doc -e LW {
range aa =1[1]:4[500];
del aa;
}
}
//It will loop over all worksheets in all workbooks and delete first 500 rows from column 1 to column 4.
Thank you very much for your quick reply. It works exactly as you said! can I ask for one more favor: is it possible to omit the range of column step? my data sets have different column numbers, would be nice if i can process the data regardlessly.
deleting rows
Posted - 04/10/2014 : 04:48:14 AM
