View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
OJ[_2_] OJ[_2_] is offline
external usenet poster
 
Posts: 111
Default edit cell by macro

Hi,
you can do it by using this line but the macro must be called from the
worksheet not from the IDE..

With Application
.SendKeys "{F2}"
.SendKeys "I wrote this"
End With

I wouldn't recommend that approach though...maybe if you posted a bit
more info on what you are trying to achieve?
OJ