Problem with Active Cell Refence

P

patterson_m

I am just learning Macros & VBA.

I am designing a spreadsheet for picking and booking theatre seats.

Problem:

How do I get the active cell reference to show, of a selected seat,
either in a nominated cell or in a pop up message, but adjusted to
reflect offset seat rows and columns. e.g. The cell reference of Seat
A1 may be D5, seat A2 would be D6 and so on.

I want the actual seat no, not the actual cell reference.

The best I have managed so far is get the actual active cell reference
(which of course isn't the seat no) and then it appears as $A$1.

Hope this makes sense and isn't considered too trivial question.

Many thanks

Mark
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cell reference 5
Need to reference two cells to construct formula 1
Chart datalabels linked to cells 1
Cell Toolbar Dilemma xl2013 13
Where am I going wrong? Cells reference to a range appears to havestopped working! 5
Comparing active cell to the value in another cell 4
retrieve Active cell "Name" vbscript 3
problem with active cell 4

Top