LinkBack URL
About LinkBacks
HI,
I am receiving a debugging error beg. .range any ideas? Thanks
With Sheets("Open Trades") .Range("G2:G200").Select Selection.Copy Sheets("Open Trade Exposure").Select Range("A9").Select ActiveSheet.Paste End With End Sub
HI,
I am receiving a debugging error beg. .range any ideas? Thanks
With Sheets("Open Trades") .Range("G2:G200").Select Selection.Copy Sheets("Open Trade Exposure").Select Range("A9").Select ActiveSheet.Paste End With End Sub
Option Explicit Sub test() With Sheets("Open Trades") .Range("G2:G200").Copy Sheets("Open Trade Exposure").Range("A9").PasteSpecial xlValues 'Sheets("Open Trade Exposure").Range("A" & Rows.Count).End(xlUp).Offset(1).PasteSpecial xlValues 'if you want to paste it in to next empty row Application.CutCopyMode = 0 End With End Sub
Last edited by AB33; 07-09-2015 at 05:02 PM.
same problem
Range("D4:AA495").Select
Selection.Copy
Workbooks.Open Filename:="d:\Miguel Azar\Documents\seguros\AAAACliente.xlsm"
Sheets("resumen cliente").Select
Range("a5").Select
ActiveSheet.Paste (paste dont work , it was working fine a few day ago for few years , run-time error 1004: paste method of worksheet failed)
i have the same macro in an older file ,works perfect, seams the problem is in onedrive storage that corrupt the macro)Originally Posted by Mazar
seams the macro is corrupt ( in my case the onedrive storage seams to be the problem corrupting the macro)
i solve wit a back copy of my file) renaming editing etc not work
Mazar,
1. Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
2. Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks