Assigning a value to a row
Posted by Ben on August 23, 2000 8:49 PM
Why doesn't this work?
Dim x As Integer
x = lastcell.Row + 1
Rows("5:x").Select
lastcell worked fine for the code above this section but vb doesn't like "Rows("5:x").Select" even though x does have a value. What am I doing wrong?
Thanks.