| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy cell without border
I know this is a ridiculously simple question but I cannot find th
solution anywhere on the net or in the help files. I have data in cell that has a border around it and I want to be able to copy the dat without the border to a cell on another sheet. This code copies the border and the data: Worksheets("Sheet1").Range("B4").Copy _ Destination:=Worksheets("Sheet2").Range("E5") TIA Ke -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| border on last cell of page effects border on beginning cell of ne | Excel Discussion (Misc queries) | |||
| formating the color and border of a cell and then copy numbers int | Excel Discussion (Misc queries) | |||
| How do you copy a border down the page? | Excel Worksheet Functions | |||
| Changing the border of one cell s/n change the border of adjacent | Excel Discussion (Misc queries) | |||
| How copy format, font, color and border without copy/paste? | Excel Programming | |||
Threaded Mode
