ClearContents selectively

[EdMac]

In a macro I have the following line of code that clears all cells in the row.

Please Login or Register  to view this content.

I want it to only clear the contents of A:C, K, L:Y, AB:AC and AG:AO

I have tried adding these as a range after the rows statement but it doesn't work.

I guess there is a simple solution but as VB is not my strong point, I can't see it.

grateful any assistance

Ed

[royUK]

Do you mean

Please Login or Register  to view this content.

[EdMac]

Hi Roy,

Thanks for that.

what I want is:

Please Login or Register  to view this content.

This forms part of a larger code block (devised by jasoncw):

Please Login or Register  to view this content.

The remaining cells in the row contain formulae and, if the row is the first and only row completed, the original code (I think it's this bit)

Please Login or Register  to view this content.

deleted these and, any subsequent data input was not evaluated. If there are multiple rows the problem does not occur.

I put this in following your suggestion

Please Login or Register  to view this content.

and get 'run time error 1004'.

Is this due to too many parameters or am I misunderstanding the coding?

Ed

[royUK]

This line sets the range to a row in srcWs.

Please Login or Register  to view this content.

This part is specifing the whole column

Please Login or Register  to view this content.

Try this instead

Please Login or Register  to view this content.

[EdMac]

Hi Roy,

Thanks for that - it looks like it does exactly what I want.

Regards

Ed