formatting question
 

I'm copying data to a spreadsheet every day with a macro. When the data is
copied to the new WB, it carries over the font formattng and sheet formating
of the original WB. Is there code I can use format a column and font from
row 19458 and forward.

formatting question
 

If you want to preserve the formats already present in the new WB you can use
Selection.PasteSpecial Paste:=xlPasteValues

--
Best wishes,

Jim


"JOUIOUI" wrote:

I'm copying data to a spreadsheet every day with a macro. When the data is
copied to the new WB, it carries over the font formattng and sheet formating
of the original WB. Is there code I can use format a column and font from
row 19458 and forward.

formatting question
 

Instead of...
ActiveSheet.Paste
try
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
That will stop the formatting from being copied over.
--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"JOUIOUI" wrote:

I'm copying data to a spreadsheet every day with a macro. When the data is
copied to the new WB, it carries over the font formattng and sheet formating
of the original WB. Is there code I can use format a column and font from
row 19458 and forward.

formatting question
 

Yikes, this is not working, what am I doing wrong? I treid it with Selection
and now with rng1 and both times it failed. Thanks

rng1.Copy rng3.Offset(0, 0)
rng1.PasteSpecial Paste:=xlPasteValues


"Jim Jackson" wrote:

If you want to preserve the formats already present in the new WB you can use
Selection.PasteSpecial Paste:=xlPasteValues

--
Best wishes,

Jim


"JOUIOUI" wrote:

I'm copying data to a spreadsheet every day with a macro. When the data is
copied to the new WB, it carries over the font formattng and sheet formating
of the original WB. Is there code I can use format a column and font from
row 19458 and forward.