Copy and Paste Large data.
I have a question about using Macro to copy and paste large data to another workbookI have data with 6000 rows running up to column AK. Is this a safe approach? I am going to use this copied data to update 10 pivot tables Below is the code that I am using. Workbooks.Open Filename:= _ "S:\macro working folder\ OPS.xlsx" 'clear any thing on clipboard to maximize available memory Application.CutCopyMode = False ActiveSheet.Select Application.ScreenUpdating = False Application.DisplayAlerts = False Range("A1").Select On Error Resume Next mylastrow = Cells.Find("*", [A1], , , xlByRows, xlPrevious).Row mylastcol = Cells.Find("*", [A1], , , xlByColumns, xlPrevious).Column mylastcell = Cells(mylastrow - 1, mylastcol).Address Data_range = "A1:" & mylastcell Range(Data_range).Select Selection.Copy ActiveWindow.Close 'Paste data into new Workbook '------------------------------------------------------------------------------------------ Sheet("OPS").Select Range("A1").Select ActiveSheet.Paste Selection.AutoFit 'clear any thing on clipboard to maximize available memory Application.CutCopyMode = False I noticed that one of the column is forcing the data to look like this but it looks fine when I do it without macro. 2.01313E+12 What are my risks of using macro? I don’t want to lose data or change the data. Is there some preventive method that I need to add in my macro? Please help!!! Thank!!! -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.