Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Darla Morrison   on Mar 09 In MS Office Category.

Trying to write a simple macro to handle input!


  
Question Answered By: Jenny Lopez   on Mar 09

Actually the last row is simpler than that. (also you had a couple of typos)

You just need

Dim lastrow as long
lastrow = ActiveSheet.Range("A65536").End(xlUp).Row

there is no need to move the cursor at all.

This assumes the last row will have data in col A.

Share: 

 

This Question has 6 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Trying to write a simple macro to handle input! Or get search suggestion and latest updates.


Tagged: