Gridlines missing after Paste

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

After Copying a range of data from another workbook into my current wb
the copied area now takes on the source range format that did not have the
gridlines. I need to somehow (thru code) how to apply the grid lines to ny
destination sheet in the code after the Paste line. Can't figure out how??

Any help appreciated,
 
Try this, as far as i can see the paste formulas is what will do this for you
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
 
John, I tried by recording a macro -- this seems to work

ActiveSheet.Range("A1").Copy
Range("A8:B250").PasteSpecial Paste:=xlPasteFormats
Tks,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

prevent gridlines from excel 2007 to word 2007 1
not all the gridlines print; despite selecting/"gridlines" 1
How can I lock the gridlines in an excel spreadsheet? 1
grid lines 3
Problem: Paste Data after Source Workbook in Closed... 1
"Name" Issue? 1
Sheet format questions -- Excel 2007 2
Still Another Copy-and-Paste Macro Problem 3

Back
Top