MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.


Posted by Ben on August 24, 0100 12:51 AM

I got it

Rows("5:" & x).Select works.