LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 703
Default Excel 2003 - Seleccionar caracteres duma célula - Macro

Dada coluna com número irregular de caracteres por célula (x, y) pretende-se,
com macro:
1 - inserir na célula (x, y+1) - lido na célula (x, y), da direita para a
esquerda, o 1.º e o 2.º caracteres.
2 - inserir na célula (x, y+2) - lido na célula (x, y), da direita para a
esquerda, todos os caracteres a partir do 5.º inclusive.
3 - passar Ã* linha x = x+1 e repetir a operação até que célula (x+n, y) = "".

Há 2 dias que tento encontrar saÃ*das, mas continuo "em casa". Alguém me pode
ajudar?

--
Charlie Brown
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel 2003 + macro help Neil Holden Excel Discussion (Misc queries) 2 March 17th 10 05:56 PM
como aumentar um valor numa célula picando só com o rato jorge passos Excel Discussion (Misc queries) 2 November 4th 09 09:56 PM
how to run acces 2003 macro in excell 2003 macro gonggo Excel Discussion (Misc queries) 0 October 6th 09 11:45 AM
Falta de espaço na célula para a inserção da fórmula Luis Excel Discussion (Misc queries) 0 July 23rd 08 12:35 PM
macro in excel 2003 constance Excel Worksheet Functions 1 March 21st 05 09:50 AM


All times are GMT +1. The time now is 07:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"