| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I get the row number?
Hi,
The code snippet below will copy data from a certain row plus other info to a different sheet. I would like it to include the row number (at the end) of the row copied from for ease of identification in the future. Any ideas welcomed. .Range("B" & lngNewRow).Value = Sheets("claims").Range("D" & lngRowNo) .Range("C" & lngNewRow).Value = Sheets("claims").Range("E" & lngRowNo) .Range("H" & lngNewRow).Value = UserForm8.TextBox1.Text .Range("I" & lngNewRow).Value = UserName() .Range("J" & lngNewRow).Value = Format(Date, "dd mmm") .Range("K" & lngNewRow).Value = Format(Time, "hh:mm") .Range("L" & lngNewRow).Value = rownumber() Thanks -- Traa Dy Liooar Jock |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I get the row number?
Jock,
Isn't it lngRowNo you want ..Range("L" & lngNewRow).Value = lngRowNo Mike "Jock" wrote: Hi, The code snippet below will copy data from a certain row plus other info to a different sheet. I would like it to include the row number (at the end) of the row copied from for ease of identification in the future. Any ideas welcomed. .Range("B" & lngNewRow).Value = Sheets("claims").Range("D" & lngRowNo) .Range("C" & lngNewRow).Value = Sheets("claims").Range("E" & lngRowNo) .Range("H" & lngNewRow).Value = UserForm8.TextBox1.Text .Range("I" & lngNewRow).Value = UserName() .Range("J" & lngNewRow).Value = Format(Date, "dd mmm") .Range("K" & lngNewRow).Value = Format(Time, "hh:mm") .Range("L" & lngNewRow).Value = rownumber() Thanks -- Traa Dy Liooar Jock |
| 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) | |||
| find an exact number in a different sheet and use the cell containing the number to output information | Excel Programming | |||
Linear Mode
