Gridlines missing after Paste
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, |
Gridlines missing after Paste
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 Please rate when your question is answered to help us and others know what is helpful. "JMay" wrote: 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, |
Gridlines missing after Paste
John, I tried by recording a macro -- this seems to work
ActiveSheet.Range("A1").Copy Range("A8:B250").PasteSpecial Paste:=xlPasteFormats Tks, "John Bundy" wrote: 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 Please rate when your question is answered to help us and others know what is helpful. "JMay" wrote: 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, |
All times are GMT +1. The time now is 04:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com