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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.