jmac001
asked on
VBA Copy Range
Hi,
Could I please get assistance would like to update the range so that if the file is updated and goes paste 1321 the data is captured?
Here is my code so far:
Could I please get assistance would like to update the range so that if the file is updated and goes paste 1321 the data is captured?
Here is my code so far:
Set wbPaste = ActiveWorkbook
Set wbCopy = Workbooks.Open("\Phased.XLS")
Set wsCopy = wbCopy.Worksheets("SS")
Set rngCopy = wsCopy.Range("A5:HX1321")
Set wsPaste = wbPaste.Worksheets("DataSheet")
Set rngPaste = wsPaste.Range("a4")
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER