if data is in a1:g50, a control end takes you to g50
if i want to clear this data, how do i reset the usedrange back to a1?

i have tried delete, clear and clearcontents, but a control end still takes
me to g50

--


Gary