Copy range and paste on sheet in same workbook

[Chris1976]

Hi There ,

I have this short code to copy a range of cells from a template to the last found row on a existing sheet within my workbook. Weird thing is, when its copied (works fine) it leaves that copy border (doted lines) on the sheet that is has been pasted to - further weird that the doted border is not even at the correct location

is it something in the code perhaps ?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[sintek]

Cannot test or see your "marching ants" scenario as no sample file...

Please Login or Register  to view this content.

[Chris1976]

Howzit Sintek , do i replace that entire

Please Login or Register  to view this content.

with just this

Please Login or Register  to view this content.

and end with

ActiveSheet.Paste


End Sub

[sintek]

Chris...I do not have a sample file so cannot see what you are wanting to achieve...
If it is copying from template A2:K and lastrow on Template to first available row on Summary_Maint_List then...

Please Login or Register  to view this content.

Also...
Please take a moment to read our forum rules...here
Your post does not comply with Rule # 2
2. Programming code must be enclosed in code tags to improve readability. (A, Z)

Please Login or Register  to view this content.

So...Edit your post...Highlight the code and press the # button

[Chris1976]

My apologies I noticed that I did not bracket the code , sorry about that

Just general question Syntek

what does the

Please Login or Register  to view this content.

(2) mean at the end ?

[sintek]

Thanks for amending code tags...Moderators are rather strict on rules...
Basically just offsets from last row|cell...
See here

[Chris1976]

No problem was my fault , cool I will have a read through those

The code suggestion in post #4, works perfect, thanks again Syntex , much appreciated - much shorter and no more "marching ants"... hehehe!