Clear Row Cells After Macro Runs

[xjohnson]

Hi,

I have a shape which runs a macro (Post Services to 'Service Log'). It does post the selected rows to the 'Service Log' sheet just fine.

My question is on the '2011 Ford F150' sheet can this also clear columns F,G,H,I, and K after running the macro and also update columns A and B from C and D for the selected services?

Thank you I appreciate any help

[JLGWhiz]

Please Login or Register  to view this content.

Not sure what the below statement means.

and also update columns A and B from C and D

[xjohnson]

Thank you for the reply and code change. I ran it and it gets error at:

Sheets ("2011 Ford F150"), Range("C" & r).Resize(, 7).ClearContents

The statement means to put the date and O/D from columns C and D (these are filled when selecting check boxes) and put them in A and B.

[xjohnson]

Hello,

I went back to my original code and after the code runs H,I, and K are the only ones left that need to be cleared.

It still needs the Date and O/D updated though.

Thank you very much for helping

[xjohnson]

I got the cells to clear with this code but I still can't figure out how to update the Date and O/D.

Please Login or Register  to view this content.

[daboho]

I got the cells to clear with this code but I still can't figure out how to update the Date and O/D.

Please Login or Register  to view this content.

Do you mean in sheets("2011 Ford F150")
Col c and d copy to col a and b And same sheet

[xjohnson]

Yes on the '2011 Ford F150' sheet but only for the selected rows by the check boxes.

Thank you

[JLGWhiz]

Thank you for the reply and code change. I ran it and it gets error at:

Sheets ("2011 Ford F150"), Range("C" & r).Resize(, 7).ClearContents

The statement means to put the date and O/D from columns C and D (these are filled when selecting check boxes) and put them in A and B.

the error you were getting was caused by a typo. The comma should be a period.

[JLGWhiz]

See if this does what you want.

Please Login or Register  to view this content.

[xjohnson]

Compile error:

End If without block if

[JLGWhiz]

Compile error:

End If without block if

Actually, it is a With without and End With

Please Login or Register  to view this content.

Don't know why that didn't show up when I put it in the editor. Just add it in and it should then run OK.