amend code to clear contents and format in vba except row 1 in specific sheets

**JEAN1972** · 05-06-2018, 10:22 AM

Trying to clear data on two sheets only data 1 and data 2 but do not delete row1 which are headers on both sheet .

as below but not working

However the range in data 1 sheets are are from column A to O
and data 2 are from range A to G

But in both sheets there may be headers column which are blank

Can Anyone assist,

Please Login or Register  to view this content.

**AB33** · 05-06-2018, 10:36 AM

Please Login or Register  to view this content.

**alansidman** · 05-06-2018, 10:36 AM

try this:

Please Login or Register  to view this content.

amend code to clear contents and format in vba except row 1 in specific sheets

LinkBack

Thread Tools

Rate This Thread

Display

amend code to clear contents and format in vba except row 1 in specific sheets

Re: amend code to clear contents and format in vba except row 1 in specific sheets

Re: amend code to clear contents and format in vba except row 1 in specific sheets

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA code to clear contents into specific columns

[SOLVED] vba clear contents and any format in specific columns

Help To Amend The Following Code - Move Data In Another Workbook And Clear Contents

[SOLVED] code to clear all contents in columns with specific text in row 2

code that will delete and clear specific contents in the workbook

Code to clear contents of specific cells based upon if key exists in other sheets

VBA Code to amend specific sheet based on cell contents.

Bookmarks

Bookmarks

Posting Permissions