Sorry, you will need to define l_column!



smw226 wrote:
Sub Lastrow()

Dim l_column As String
l_column = "A"
Range(l_column & "65535").Select
Selection.End(xlUp).Select

End Sub

Hope this helps,

Thanks

Simon

I have a list of data that changes everytime someone runs their excel
spreadsheet. ( It is populated by another software taht we us for our
database.) I want to be able to find the first blank cell (where the
list of data ends) and enter a calculation there. How can I do this
within vba? I want to find the first blank cell and enter a formula
there, I have tried everything!! Thanks in advance!

--
Message posted via http://www.officekb.com