Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I get a macro to find the l 1

Status
Not open for further replies.

Thelemac

Programmer
May 29, 2002
26
US
How can I get a macro to find the last avaialbe row so I can put data in it?
 
Ooops, apparently I didn't fill out the subject field. Silly me. :D
 
This should do it...

Sub Last_UsedRow_Column_A()
Lastrow_A = [A65536].End(xlUp).Row
End Sub

Hope this is what you wanted. :)

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top