Gridlines missing after Paste

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,
 
G

Guest

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
 
G

Guest

John, I tried by recording a macro -- this seems to work

ActiveSheet.Range("A1").Copy
Range("A8:B250").PasteSpecial Paste:=xlPasteFormats
Tks,
 

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

not all the gridlines print; despite selecting/"gridlines" 1
Problem: Paste Data after Source Workbook in Closed... 1
Still Another Copy-and-Paste Macro Problem 3
"Name" Issue? 1
Macro to copy value in field and insert it into filter 2
Import data into Excel sheet from CSV File 3
Ron's e-mail won't work when I change the send to: 4
VBA range 5

Top