Active Cell Address – Inactive Sheet

[MrDB4Excel]

How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current, active sheet.
This is done to always show the user if a specific cell is actually the active cell in a specific inactive worksheet.
In addition, to make this seem a bit more complicated, my workbook contains 6 sheets, labeled as follows:
Current Rates, USD2CZK Log, EUR2CZK Log, CZK2EUR Log, RUB2EUR Log, EUR2RUB Log.
I want to use VBA to get the cell address of the active cell in each of the sheets USD2CZK Log, EUR2CZK Log, CZK2EUR Log, RUB2EUR Log, EUR2RUB Log and place those cell references, 5 in all, on sheet Current Rates. (Incidentally, these active cell addresses are empty, no data is present)
In addition, the indicated cell addresses of the active cells in those 5 sheets are directly below, in the same column of those 5 sheets, the last entered data. So for example VBA’s results indicate the active cell in each of those 5 sheets is B678. I need to also have VBA return the cell address of the cell above the active cell wherein the last data was entered, in this example, B677.
I assume the VBA involved would need an entry for each of the 5 sheets.
I hope this is an easy fix, any help is greatly appreciated. I have scoured several web pages to find an answer and do not seem to find anything that remotely applies, close, but no cigar.

 

[mikerickson]

You could put code like this in every worksheet's code module

Public Selection As Range

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Set Selection = Target
End Sub

and refer to Worksheets("foo").Selection as needed.

 

[MrDB4Excel]

You can try clicking the 'Report' button on the first post of that thread and asking admin to delete it.
If you do, I would strongly advise waiting until it has been done before posting a new one in order to avoid falling foul of the duplicate thread rules.

Jason,
How long might it take for admin to delete the original post? I did the report about 5 hours ago.
If I look for the original post and find it I can assume that they have not yet deleted the original?

 

[jasonb75]

Most of the time it would be done in a matter of minutes (can be longer at weekends, they are all volunteers with other commitments outside of the forum).
It has been deleted, I just tried the link that you posted earlier.

 

[MrDB4Excel]

Most of the time it would be done in a matter of minutes (can be longer at weekends, they are all volunteers with other commitments outside of the forum).
It has been deleted, I just tried the link that you posted earlier.

Thanks, Jason, you have been most helpful.
I will repost tomorrow as it is just after midnight here in the Czech Republic.