If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copying GridLines with AutoFill
I have a fill macro assigned to a worksheet that is designed to only copy over items that show a quanity of one or more items. If the macro detects a quanity of one or more for a particular item it copies that item over to another Quote worksheet.
The problem is that when the data is being copied over to the Quote worksheet it is also copying over all the gridlines that surround the data from the main worksheet. How do I make this macro ONLY copy over the text information and not the gridline formatting that surrounds the data when this macro is ran? Thx! |
#2
|
|||
|
|||
Copying GridLines with AutoFill
Elusive,
Instead of doing a Copy/Paste, simply set the value of the target cell equal to that of the source cell. That is, instead of Worksheets("Source").Range("A1").Copy Worksheets("Quote").Range("B2") use Worksheets("Quote").Range("B2").Value = Range("A1").Value If that doesn't fit your code, then post your code. HTH, Bernie MS Excel MVP "Elusive" wrote in message ... I have a fill macro assigned to a worksheet that is designed to only copy over items that show a quanity of one or more items. If the macro detects a quanity of one or more for a particular item it copies that item over to another Quote worksheet. The problem is that when the data is being copied over to the Quote worksheet it is also copying over all the gridlines that surround the data from the main worksheet. How do I make this macro ONLY copy over the text information and not the gridline formatting that surrounds the data when this macro is ran? Thx! |
Thread Tools | |
Display Modes | |
|
|