VBA Macro Code Problem - Cuts and Pastes Sheet Header - nightmare!

Hi guys,

I have a spreadsheet with several sheets which I am having a few problems with. Basically I have set up the below code so that VBA will apply an autofilter which looks for a certain criteria in a column and then cuts and pastes the relevant row to the next sheet before deleting the row in the first sheet and moving the rows up. The criteria that the autofilter looks for is "Yes."

Please Login or Register  to view this content.

Basically the problem I am encountering is that when I click the update button, it cuts and pastes the column header as well as the update button into the next sheet which obviously I don't want it to do.

Can anyone please point me in the right direction with this?

Many thanks

hi micropscotts, welcome to Excelforum

Please Login or Register  to view this content.

Hi watersev,

I added the above line of code to my VBA script and although this does omit the header line, it now only copies and pastes the cell which the autofilter is looking for data in (ie the data in the cells in column "n")

Maybe Change:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Originally Posted by JOHN H. DAVIS

Maybe Change:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

That's cracked the little bugger! Awesome work John H Davis! Rep+1'ded

You're welcome. Glad my 2 cents helped.