Copying GridLines with AutoFill

E

Elusive

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!
 
B

Bernie Deitrick

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 said:
I have a fill macro assigned to a worksheet that is designed to only copy
Click to expand...
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
Click to expand...
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
Click to expand...
gridline formatting that surrounds the data when this macro is ran?
 
Top