macro to select 'all' and delete contents.

**emilyloz** · 07-29-2013, 03:56 PM

Hi.

I currently have this sub

Please Login or Register  to view this content.

But its not working.

The data will always range from column A to column AA
and will start on cell A6

Please help.

**emilyloz** · 07-29-2013, 03:59 PM

Or Is there a way for me to select A6 and then run the command "Ctrl A?"

**oeldere** · 07-29-2013, 04:11 PM

Please Login or Register  to view this content.

try change it in this line

Please Login or Register  to view this content.

First is the row, Second is the column so you got to changes at least the second part => column 27 = AA

**AB33** · 07-29-2013, 04:15 PM

Please Login or Register  to view this content.

**emilyloz** · 07-30-2013, 09:08 AM

ActiveSheet.Range("A6:AA" & Cells(Rows.Count, 1).End(xlUp).Row).ClearContents

Thank you!

Re: macro to select 'all' and delete contents.