Macro/VBA help

[mki16101]

Hi,

I would like to create a macro/vba/script (really anything that makes sense) to do the following things

I want to run thru all the tabs that are within a excel worksheet and find the last entry for a specific column.

I want the program to display two things. Find the last entry of a column (lets say column C of the attached file) and the sheet name associated with it.

any help would be appreciated.

thank you!

[MrGes]

Hi,
try this

Please Login or Register  to view this content.

[mki16101]

Thank you so much. It does the job. Thank you!

A favor: I want to learn how you came up with this code. Would it be possible to add some comments. I do not have a lot of experience with excel coding.
Also, can i get it in the "Immediate" window instead of the result being a message

[mki16101]

I want to copy the result that I get out of the code. As it comes out as a message, I can't copy it

[MrGes]

can i get it in the "Immediate" window instead of the result being a message

Please Login or Register  to view this content.

[Richard Buttrey]

Also, can i get it in the "Immediate" window instead of the result being a message

Perhaps

Please Login or Register  to view this content.

[mki16101]

thank you for explaining the code in such great details. But I am still unable to copy the message. Any thoughts?

[mki16101]

Thank you Richard and MrGes. I am all set. thank you

[Richard Buttrey]

Maybe write the message to a cell and then copy the cell. i.e.

Please Login or Register  to view this content.

[MrGes]

Copy with CTRL+C