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.
