ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   database formatting (https://www.excelbanter.com/excel-discussion-misc-queries/14082-database-formatting.html)

Scribner

database formatting
 
I am using a macro to transfer into my database, but the formatting from the
input sheet disrupts my database formatting. I was wondering it you could
help me only transfer the data with my macro and not the formatting.

Myrna Larson

If you are now using Copy and Paste, use Copy and PasteSpecial, pasting only
Values.

On Sat, 19 Feb 2005 20:33:01 -0800, "Scribner"
wrote:

I am using a macro to transfer into my database, but the formatting from the
input sheet disrupts my database formatting. I was wondering it you could
help me only transfer the data with my macro and not the formatting.




All times are GMT +1. The time now is 02:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com