[b]clear specific or range of cells before macros' run[/b]

**chergian** · 05-13-2014, 09:56 PM

Hello Everyone,

I have this code that paste data to another worksheet:

Please Login or Register  to view this content.

This is my little problem. I want to clear specific or range of cells on destination worksheets before that code run. Example, i want to clear cells J11:J20, I23, I34:I35 on destination.xls "Sheet1", cells I10, I14:I19 on "Sheet2", and so on...

I know someone there have a solution for this little prob...

More Power!

**sktneer** · 05-13-2014, 11:21 PM

You may need to include following variables and lines of code to your code......

Please Login or Register  to view this content.

Does this help?

[b]clear specific or range of cells before macros' run[/b]

LinkBack

Thread Tools

Rate This Thread

Display

[b]clear specific or range of cells before macros' run[/b]

Re: [b]clear specific or range of cells before macros' run[/b]

Thread Information

Users Browsing this Thread

Similar Threads

macro to clear a range in specific sheets

[SOLVED] Clear contents of specific cells on the same row if a specific cell on that row is empty

[SOLVED] Clear specific cells

[SOLVED] Conditionally Clear Contents for Specific Range

Clear contents of cells that do not contain specific text, sort cells that do

Bookmarks

Bookmarks

Posting Permissions