enfantter
10-16-2007, 12:38 AM
Hey all,
Im difining a range, like below
Set Rng2 = Sheets("Indtastning af ny opgave").range("b2:b60")
The problem is that the range is take from an input sheet in which it is very likely that there can be added extra records, so instead of b60 i would like to have a dynamic piece of code.
Something like b"lastrow"...
does anyone know how to do this?!
Im difining a range, like below
Set Rng2 = Sheets("Indtastning af ny opgave").range("b2:b60")
The problem is that the range is take from an input sheet in which it is very likely that there can be added extra records, so instead of b60 i would like to have a dynamic piece of code.
Something like b"lastrow"...
does anyone know how to do this?!