Extending the range of the current code

Hi Forum

Below is some code, currently the code displays only in one row specifically cells A1,B1,C1, I need the same functions to happen for an additional 9 rows. Ive tried and failed for the last couple of hours trying to adjust it.

Please Login or Register  to view this content.

Any help would be greatly appreciated

1) please note that moderator edited your post and added code tags - see http://www.excelforum.com/forum-rule...rum-rules.html why
2) Try:

Please Login or Register  to view this content.

You should also really disable events if you are going to change cells in a Change event.

Basically - yes, but here we change only "non-triggering" cells, so for changed cells cell.offset(0,x), where x=1;2

Please Login or Register  to view this content.

Is Nothing

I know but you're still doing unnecessary processing by raising the event again, and if the code changes in future it will be easy to overlook (at first anyway!). IMO, it's better practice to disable events if you're going to do something that will raise that event again.

As usually - there are pros and cons.
I am not 100% convinced.
You mentioned pro, so let me raise con
If for some reason code stops while events are disabled, they will remain disabled until: either explicitely enabled by user (rather experienced one only) or excel is restarted.
Especially for less experienced users it can be really frustrating situation.

Just to show coys1717: code which includes Rory suggestion could be:

Please Login or Register  to view this content.

That's what error handlers are for.