ExKel

  • Thread starter direct macro to certain cell
  • Start date
D

direct macro to certain cell

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.
 
F

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
Click to expand...
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

L. Howard Kittle

Or, how can I make my data go to a cell directly under my current table?
Click to expand...
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

direct macro to certain cell said:
I want to direct a macro to enter data in the cell I have currently
Click to expand...
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.
 
Top