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?