Thread
:
Copy Destination
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_2_]
external usenet poster
Posts: 1,522
Copy Destination
2+4 =6
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Charles" wrote in message
...
HI,
The fowling code does not work as designed
Sheets("Raw Data").Range(Cells(7, Mycol), Cells(397, Mycol + 4)).Copy
Destination:=MyWkBook.Sheets("Raw Data").Range(Myrng)
However if I changed it to
Sheets("Raw Data").Range("B7:F397").Copy
Destination:=MyWkBook.Sheets("Raw Data").Range(Myrng)
It works.
MyCol should = 2 because a Find determined that the item I was looking
for is in column 2.
Any help with this problem would be appreciated.
Reply With Quote
Don Guillett[_2_]
View Public Profile
Find all posts by Don Guillett[_2_]