View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jodleren jodleren is offline
external usenet poster
 
Posts: 49
Default Clearing used range?

I want to clear data, meaning that I delete anything below row 4, en
after say "D"

Right now it jumps to EE10000 as the last cell, eg highest cell.

This code does not work

ws.Rows("200:65536").EntireRow.Delete
ws.Columns("Z:IV").EntireColumn.Delete
ws.UsedRange ' invalid use of property?

Sonnich