VBA Command - I need help Please!

[Wendy5]

Does anyone know what the proper command in Excel VBA is to "Enter"? What I mean is that I am programming something in it and the last required step (so I am told) is to emulate pressing the "Enter" key but I have no idea how to do that! Any help would be appreciated!!

Wendy

[Tom Ogilvy]

Sub BBAA()
SendKeys "~", False
End Sub

--
Regards,
Tom Ogilvy




"Wendy5" wrote:

>
>
>
> Does anyone know what the proper command in Excel VBA is to "Enter"?
> What I mean is that I am programming something in it and the last
> required step (so I am told) is to emulate pressing the "Enter" key but
> I have no idea how to do that! Any help would be appreciated!!
>
> Wendy
>
>
> --
> Wendy5
> ------------------------------------------------------------------------
> Wendy5's Profile: http://www.excelforum.com/member.php...o&userid=34764
> View this thread: http://www.excelforum.com/showthread...hreadid=545256
>
>

[Wendy5]

Thank you for the information but it did not work. Do you have any other ideas?

[Dave Peterson]

I think I'd go back to that person who said to "enter" the data to find out what
he/she meant.

Wendy5 wrote:
>
> Thank you for the information but it did not work. Do you have any other
> ideas?
>
> --
> Wendy5
> ------------------------------------------------------------------------
> Wendy5's Profile: http://www.excelforum.com/member.php...o&userid=34764
> View this thread: http://www.excelforum.com/showthread...hreadid=545256

--

Dave Peterson