Clear Contents in an another worksheet

**Keibri** · 08-26-2015, 01:40 AM

Hi all,

Hope all is well. I need a simple VBA which will basically clear the contents of a range of cells found in another Sheet.

Therefore if I am on 'sheet 1'as soon as the VBA code is run it will clear the contents of cells A1:D40 found in 'Sheet 2'.

Apologies for being such a noobie

Thanks in advance for your kind help

**BadlySpelledBuoy** · 08-26-2015, 01:48 AM

Sheets("Sheet 2").Range("A1:D40").Clear

BSB

**Keibri** · 08-26-2015, 02:19 AM

Cheers

!!! Thanks a ton!!! That worked very good!

**BadlySpelledBuoy** · 08-26-2015, 02:21 AM

No problem. Happy to help

BSB

Clear Contents in an another worksheet

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Clear Contents in an another worksheet

Re: Clear Contents in an another worksheet

Re: Clear Contents in an another worksheet

Re: Clear Contents in an another worksheet

Thread Information

Users Browsing this Thread

Similar Threads

Clear merged cell contents in comand button(clear all)

clear contents of entire sheet except the contents of the table

[SOLVED] Clear Cell Contents on Worksheet Change

[SOLVED] Clear Contents in Multiple WorkSheet

Clear Contents of Cells On Another Worksheet

Copy list contents down, then clear contents

Clear sheet contents but retain Clipboard contents

Bookmarks

Bookmarks

Posting Permissions