Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
number consequetively
Is there a way to number items after I've pasted them into a new tab.
Unfortunately the data is not right next to the items I've pasted. This pastes the items into Row 3 Column D ... but now I need to number these items consequetively numbered beginning in Column B3. Private Sub CommandButton1_Click() 'Application.ScreenUpdating = False 'Application.Calculation = xlCalculationManual lastRow = Sheets("Input Names").Cells(Rows.Count, "C").End(xlUp).Row Lastcolumn = Sheets("Input Names").Cells(1, Columns.Count).End(xlToLeft).Column With Sheets("Input Names") .Range(.Cells(3, 3), .Cells(lastRow, Lastcolumn)).Copy Sheets("Scores").Cells(3, 4) End With End Sub Thanks again |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
number consequetively
Add to the end of your sub after "end with"
Sheets("Scores").Range("B3") = 1 Sheets("Scores").Range("B4") = 2 Sheets("Scores").Range("B3:B4").AutoFill _ Destination:=Sheets("Scores").Range("B3:B" & LastRow) "Joe Schmoe" wrote: Is there a way to number items after I've pasted them into a new tab. Unfortunately the data is not right next to the items I've pasted. This pastes the items into Row 3 Column D ... but now I need to number these items consequetively numbered beginning in Column B3. Private Sub CommandButton1_Click() 'Application.ScreenUpdating = False 'Application.Calculation = xlCalculationManual lastRow = Sheets("Input Names").Cells(Rows.Count, "C").End(xlUp).Row Lastcolumn = Sheets("Input Names").Cells(1, Columns.Count).End(xlToLeft).Column With Sheets("Input Names") .Range(.Cells(3, 3), .Cells(lastRow, Lastcolumn)).Copy Sheets("Scores").Cells(3, 4) End With End Sub Thanks again . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
number consequetively
I assume you want the enumeration in the sheet you pasted into.
Sub numb() Dim lr As Long, rng As Range, sh As Worksheet Dim c As Range Set sh = Sheets(1) lr = sh.Cells(Rows.Count, 3).End(xlUp).Row Set rng = sh.Range("B4:B" & lr) Range("B3").Value = 1 For Each c In rng c = c.Offset(-1, 0).Value + 1 Next End Sub "Joe Schmoe" wrote in message ... Is there a way to number items after I've pasted them into a new tab. Unfortunately the data is not right next to the items I've pasted. This pastes the items into Row 3 Column D ... but now I need to number these items consequetively numbered beginning in Column B3. Private Sub CommandButton1_Click() 'Application.ScreenUpdating = False 'Application.Calculation = xlCalculationManual lastRow = Sheets("Input Names").Cells(Rows.Count, "C").End(xlUp).Row Lastcolumn = Sheets("Input Names").Cells(1, Columns.Count).End(xlToLeft).Column With Sheets("Input Names") .Range(.Cells(3, 3), .Cells(lastRow, Lastcolumn)).Copy Sheets("Scores").Cells(3, 4) End With End Sub Thanks again |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif number is greater than a number but less than another number | Excel Discussion (Misc queries) | |||
How can I click on a telephone number in an Excel 2002 spreadsheet, and have the number dialed? | Excel Discussion (Misc queries) | |||
Inserting a number of rows based on the number of columns filled bytext values | Excel Programming | |||
How to calculate number of occurencies of a specific number number | Excel Discussion (Misc queries) | |||
Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions |