ExKel

[Guest]

I want to direct a macro to enter data in the cell I have currently selected. Right now my destination is set to range "$A$1". How can I make it go to the cell I have currently selected? Or, how can I make my data go to a cell directly under my current table? I'd really appreciate your help.

 

[Frank Kabel]

Hi
maybe something like
activecell.value = "mynewvalue"

--
Regards
Frank Kabel
Frankfurt, Germany

"direct macro to certain cell" <[email protected]>
schrieb im Newsbeitrag

I want to direct a macro to enter data in the cell I have currently

selected. Right now my destination is set to range "$A$1". How can I
make it go to the cell I have currently selected? Or, how can I make
my data go to a cell directly under my current table? I'd really
appreciate your help.

 

[L. Howard Kittle]

Or, how can I make my data go to a cell directly under my current table?

I'd really appreciate your help.

To make the data go to the cell below your selection try:

ActiveCell.Offset(1,0).Value = "mynewvalue"

HTH
Regards,
Howard

I want to direct a macro to enter data in the cell I have currently

selected. Right now my destination is set to range "$A$1". How can I make
it go to the cell I have currently selected? Or, how can I make my data go
to a cell directly under my current table? I'd really appreciate your help.