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
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL