Changing a VBA code to select cells from a range +one other cell outside the range
I have a working VBA code which copies from a range of cells in a row from a worksheet and pastes them into another sheet.
InvSheet.Range(InvSheet.Cells(iRow, "B"), InvSheet.Cells(iRow, "K")).Copy
BatchSheet.Cells(oRow, "D").PasteSpecial xlPasteValues
iRow = iRow + 1
oRow = oRow + 1
Loop Until IsEmpty(InvSheet.Cells(iRow, "B")) Or InvSheet.Cells(iRow, "B") = 0
I need to make a change to this so that it picks one additional cell and copies its contents.
ie (Range (same row) A to K) + (same Row) Z
Can anyone help changing the code above?
By Chaitanya Marvici in forum ASP.NET
Last Post: 07-21-2003, 10:15 AM
By Edwin in forum Database
Last Post: 03-06-2002, 12:58 PM
By Cary R in forum Database
Last Post: 09-24-2001, 03:40 PM
Last Post: 01-16-2001, 06:07 PM
By Bob Hines in forum Database
Last Post: 04-13-2000, 02:53 PM
Tags for this Thread
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center