dim oUsed as range

set oUsed=activesheet.usedrange
set oUsed=oUsed.resize(oused.rows.count-5,2)
set oUsed=oUsed.offset(5,0)


regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm

"Simon Lenn" wrote in message
om...
I invoke the UsedRange and get the range as A14:B55 but I want to
subtract the first 5 rows from this used range how can I remove the
rows A14:B20 from the above range.

Thanks
Simon