View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PamG[_2_] PamG[_2_] is offline
external usenet poster
 
Posts: 3
Default Copy row to different worksheet

I want to copy a row of data in one worksheet (Wkst 1) to the first blank row
in another worksheet (Wkst 2). The problem is that Wkst 2 has an additional
column as column 1, so I want to copy the row (which starts on column A) in
Wkst 1 to Wkst 2 starting at column B.


If IsError(Application.Match(CStr(R.Value), V, 0)) = True Then
R.EntireRow.Copy Sheets("Issues").Range("B65536").End(xlUp) (2)
.EntireRow.PasteSpecial Paste:=xlPasteValues


This code copies to Wkst 2, but to column A, not column B!

Please help!

Thanks
Pam