How to reference the currently selected cell in VBA.

[beeawwb]

Hi all,

This should be a really simple question. I'm just doing some VBA cod
to switch between applications (using AppActivate) and then send
command to the new program using SendKeys.

The commands I want sent are in a list, which I would select. So, I'v
got everything in Column C, push my button, and my code runs, doin
SendKeys (CellValue)

So, what I need to know is, what's the syntax to reference the cell
currently have highlighted?

CellValue = ........

I was thinking it might be something like Target.Value or Me.Value o
something like that, but I don't know what it will be.

Thanks for the help.

-Bo

 

[beeawwb]

I figured it out.

CellValue = Selection.Cells.Valu