Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Copy
i have a bunch of military times that a user is typing in under the W column starting in cell 9. The user then hits a macro button that will take all the times they punched in and copy each one 24 times under the B column starting with cell 9. for example: 1432 is typed into Cell W9. 1432 gets copied into cell B9-B32. 1526 is typed into Cell W10. 1526 gets copied into cell B33-B56. Here is my macro code: Dim copyfield Dim pastefield1 Dim pastefield2 For counter = 9 To 200 copyfield = "W" & counter pastefield1 = (counter - 9) * 24 + 9 pastefield2 = pastefield1 + 23 pastefield1 = "B" & pastefield1 pastefield2 = "B" & pastefield2 Worksheets("Sheet1").Range(copyfield).Copy _ Destination:=Worksheets("Sheet1").Range(pastefield 1, pastefield2) Next counter End Sub I keep getting the error "Runtime error 9. Subscript out of range" Can anyone help me out why? thanks for your help -timrekdgorf ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2000 copy, edit, paste spacial, value. How Excel 2007 ?? | Excel Discussion (Misc queries) | |||
copy drop down lists from desktop excel to pocket excel | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel | |||
copy & paste spreadsheet cells from excel to outlook to excel | Excel Discussion (Misc queries) |