View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Can Sendkeys be used to send a selected no. of characters in a sin

What exactly are you trying to accomplish?

Barb Reinhardt

"Zakynthos" wrote:

Say this is the data I have contained in a single cell c1:

PT NR 25 M (14h-20h),Tu (8h-14h45),W (8h-14h45),Th (8h-14h45),F
(8h-14h45),Sa (8h-16h)

Could I configure a sendkeys statament to send say the first 11
characters/spaces, say (up as far as the first bracket for instance) ?

The reason is that I want to input the code:Application.SendKeys "{{}" to
send an open bracet to this cell followed by, say: 14h-20h, followed by a
sendkeys statement for a closed bracket?