View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jon[_21_] Jon[_21_] is offline
external usenet poster
 
Posts: 37
Default Add a border to pasted cells

I am trying to place a border around some cells I pasted using a macro.
My problem is that I don't know the location of the pasted cells
because I am pasting to the next empty row below other data. See below:

Set rng = Sheets("files").Cells(Rows.count, 2).End(xlUp)(2).Offset(2,
0)

range("C3:D5").Copy
rng.PasteSpecial xlFormats
rng.PasteSpecial xlValues

Is there a way I can place a border around the pasted cells with just
the info from this code?