Hi
Have been messing about with this all day and have only got half the job done.
I have an expanding table, which when the last cell in column I is changed I want a macro to run. I can get the cell reference but I just can not get the macro to run. I thought defining it with the "lastrow" would do the trick but apparently not. Any help would be appreciated.
Formula:
Please Login or Register to view this content.
Is this an actual list object or range?expanding table
Perhaps this...
Please Login or Register to view this content.
Last edited by Sintek; 04-29-2021 at 10:20 AM.
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
cheers pal, done a quick test and that seems to work
Post 2 does this
cheers pal, done a quick test and that seems to work
Glad I could assist...tx for rep + ... If that answers your initial query then pls mark thread as solved...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks