I know how to get the row number of the cursor in a spreadhseet (Activecell.Row), but how do I get the cursor location in a list object so that I can then insert a new row for the user at that point?
BTW, I am using tables (ListObjects) because when a row is inserted, all of my formulas are automatically inserted.
Thanks!
Can't you just use ActiveCell?
This will insert a row in the table at the active cell.
Note, if the activecell is not in the table the code will error as Intersect will return Nothing.
Please Login or Register to view this content.
That can be handled like this.
Please Login or Register to view this content.
If posting code please use code tags, see here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks