Slow learner (me)

[Asus]

I have a Workbook_SheetChange I have modified from this board. I do not know how to modify it enough.
I have one line that says

Target.EntireRow.Cut Sheets("Transfer").Cells(Rows.Count, "A").End(xlUp).Offset(1)
Case Is = ""

well there are protected (or hidden cells in that row). so what do I say to stop the code from selecting the entire row. I only want the first 9 cells. really.

Thanks

 

[Greg Truby]

just shootin' from the hip here, but something like this should do the trick

Range("A" & Target.Row).resize(,9).Cut Sheets("Transfer").Cells(Rows.Count, "A").End(xlUp).Offset(1)

BTW, you got something against code tags?

EDIT -- Since you only posted the one line, it's tough to tell. But I do hope you've go some APPLICATION.ENABLEEVENTS toggles in there somewhere.

 

[Asus]

No that was just a excerpt from the code. BTW I am new to this and not too sure of what i am doing. It would have been easier to learn this stuff 30 or 40 years ago when the mind absobed a bit better. Rightnow I am just picking up bits and peices from all the smart people here in on the board.
thanks for the info.