Cell value = active selection?

[JJGF]

where ever the cursor box is, show the value of that selection in C1

[Tony Valko]

You need an event macro to do this.

Select the sheet that you want this to happen in.

Right click the sheet tab and select: View code

Copy the code below and paste it into the right side of the window that opens:

Please Login or Register  to view this content.

Close the window to return to Excel
Try it out!

[JJGF]

You need an event macro to do this.

Select the sheet that you want this to happen in.

Right click the sheet tab and select: View code

Copy the code below and paste it into the right side of the window that opens:

Please Login or Register  to view this content.

Close the window to return to Excel
Try it out!

Cool, thanks, I just had to change .Address to .Value and I got the cell contents

[Tony Valko]

You're welcome. Thanks for the feedback!