PDA

View Full Version : Clear contents in the last populated cell



av8tordude
02-01-2011, 09:20 AM
What code would clear the contents in the last populated cell in column AU. Thanks

mancubus
02-01-2011, 09:31 AM
one cell?


Range("AU65536").End(xlUp).ClearContents

Kenneth Hobs
02-01-2011, 09:32 AM
Worksheets("Sheet1").Range("AU" & Rows.Count).End(xlUp).Clear

av8tordude
02-01-2011, 09:41 AM
found the answer...thank you

thank you Ken. Your post and mine cross path


Range("AU10").End(xlDown).ClearContents