How can I return a Cell reference to a variable.
 

Hi, it's possible in several ways. I use the following method :

Dim rngCurrent as Range

Set rngCurrent = Selection

then you can format this range like this :

rngCurrent.Font.Size = 8

But if you put this code in selection change event and make a drop'n
drag, selection will change and probably you'll create an error.


---
Message posted from http://www.ExcelForum.com/