| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving the last cell in a column and using this row number in a counter
I want the row number of the last cell in a column (column A) to be the 'To'
value in the counter below For cnt = 1 To 500 ....... So i do not want to put 500 there, but the row of the last cell that contains a value.(there are empty rows!) Lets say the last cell would be A5412 What do i have to put there in place of the '500' Thanx, Luc -------------------------------------------------------------------------------- Mijn Postvak In wordt beschermd door SPAMfighter 323 spam-mails zijn er tot op heden geblokkeerd. Download de gratis SPAMfighter vandaag nog! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Retrieving the last cell in a column and using this row number in
dim lngLastRow as Long
lngLastRow = cells(rows.count, "A").End(xlUp).Row for cnt = 1 to lngLastRow -- HTH... Jim Thomlinson "Luc" wrote: I want the row number of the last cell in a column (column A) to be the 'To' value in the counter below For cnt = 1 To 500 ....... So i do not want to put 500 there, but the row of the last cell that contains a value.(there are empty rows!) Lets say the last cell would be A5412 What do i have to put there in place of the '500' Thanx, Luc -------------------------------------------------------------------------------- Mijn Postvak In wordt beschermd door SPAMfighter 323 spam-mails zijn er tot op heden geblokkeerd. Download de gratis SPAMfighter vandaag nog! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Retrieving the last cell in a column and using this row number in
Thanxxxxx,
That did the job !! Greetzzzzz, Luc "Jim Thomlinson" wrote in message ... dim lngLastRow as Long lngLastRow = cells(rows.count, "A").End(xlUp).Row for cnt = 1 to lngLastRow -- HTH... Jim Thomlinson "Luc" wrote: I want the row number of the last cell in a column (column A) to be the 'To' value in the counter below For cnt = 1 To 500 ....... So i do not want to put 500 there, but the row of the last cell that contains a value.(there are empty rows!) Lets say the last cell would be A5412 What do i have to put there in place of the '500' Thanx, Luc -------------------------------------------------------------------------------- Mijn Postvak In wordt beschermd door SPAMfighter 323 spam-mails zijn er tot op heden geblokkeerd. Download de gratis SPAMfighter vandaag nog! -------------------------------------------------------------------------------- Mijn Postvak In wordt beschermd door SPAMfighter 323 spam-mails zijn er tot op heden geblokkeerd. Download de gratis SPAMfighter vandaag nog! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding Counter to column for number of identical file numbers | Excel Discussion (Misc queries) | |||
| Retrieving page number count from Word DOC | Excel Programming | |||
| Retrieving data from a corresponding row from a different column | Excel Discussion (Misc queries) | |||
| Counter for inserting sequence of numbers in Column C | Excel Programming | |||
| Retrieving Value From Column A | Excel Programming | |||
Linear Mode
