Saltar al contenido
PROGRAMAR EN VBA MACROS DE EXCEL

Como poner mayuscula y minuscula a un rango de datos


(adsbygoogle = window.adsbygoogle || []).push({});

Algo bastante común es transformar mayúsculas en minúsculas o en forma inversa minúsculas en mayúsculas, en este post presentó una macro para tener a mano casi siempre que se desea trabajar con cadenas de texto, descargando el ejemplo podrás ver una macro que muestra como poner mayúsculas y minúsculas.

Es posible que quizás sea de interés como poner mayúscula en la primer letra o como dar formato de negrita solo a mayúsculas, como trabajar con cadena de texto, como recorrer una cadena de texto, como buscar y reemplazar una cadena de texto.

Antes de seguir recomiendo leer un excelente libro sobre Excel que te ayudará operar las planillas u hojas de cálculo, haz click acá, si quieres aprender sobre Excel, en inglés, entonces debes hacer click here. Si lo que necesitas es aprender o profundizar sobre la programación de macros con VBA este es unos de los mejores cursos on line que he visto en internet.

  
Desde el final podrás descargar el ejemplo de macro denominado como poner mayúsculas y minúsculas, el código es libre y no tiene restricción alguna por lo que se autoriza su uso, descargado el ejemplo se podrá observar al abrir el fichero dos botones uno para pasar a mayúsculas y otro para pasar a minúsculas.

En el caso que puedas considera aportar para sostener el sitio y según incorporando nuevos ejemplos que podrás descargar en forma gratuita, en caso que no puedas solicitó compartas el conocimiento con tus amigos en redes sociales.

La macro es muy simple realiza un bucle entre la primer y última fila con datos recorriendo cada unas de las celdas del rango y transformando en minúscula o mayúscula dependiendo de la macro, el código que realiza esta acción es el siguiente:

Para tansformar en mayúscula se utiliza:

Range(«A» & x) = UCase(Range(«A» & x))

Para tansformar en minúscula se utiliza:

Range(«A» & x) = LCase(Range(«A» & x))

El vídeo que sigue muestra una explicación más detallada y gráfica de la macro presentada, recomiendo observar para una más fácil comprensión de la macro; suscribe a nuestra web desde la parte superior derecha de la página ingresando tu mail y a nuestro canal de You Tube para recibir en tu correo vídeos explicativos sobre macros interesantes, como  por ejemplo como ingresar solo números en textbox, macro que copia hoja activa y guarda como, como crear una factura o sale invoice y grabar guardar PDF XLS y enviar por mailconectar Excel con Access y muchos ejemplos más.

function onYtEvent(payload) {
if (payload.eventType == ‘subscribe’) {
// Add code to handle subscribe event.
} else if (payload.eventType == ‘unsubscribe’) {
// Add code to handle unsubscribe event.
}
if (window.console) { // for debugging only
window.console.log(‘YT event: ‘, payload);
}
}

 

Código que se inserta en un módulo

Sub Mayuscula()
Application.ScreenUpdating = False
On Error Resume Next
Set a = Sheets(«Hoja1»)
uf = a.Range(«A» & Rows.Count).End(xlUp).Row
For x = 2 To uf
Range(«A» & x) = UCase(Range(«A» & x))
Next x
Application.ScreenUpdating = True
End Sub

Sub Minuscula()
Application.ScreenUpdating = False
On Error Resume Next
Set a = Sheets(«Hoja1»)
uf = a.Range(«A» & Rows.Count).End(xlUp).Row
For x = 2 To uf
Range(«A» & x) = LCase(Range(«A» & x))
Next x
Application.ScreenUpdating = True
End Sub

Si te fue de utilidad puedes INVITARME UN CAFÉ y de esta manera ayudar a seguir manteniendo la página, CLICK para descargar en ejemplo en forma gratuita.


(adsbygoogle = window.adsbygoogle || []).push({});

If this post was helpful INVITE ME A COFFEE and so help keep up the page, CLICK to download free example.

Si te gustó por favor compártelo con tus amigos
If you liked please share it with your friends      

Entradas relacionadas

Deja un comentario

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *

Comentarios (130)

I’m the business owner of JustCBD Store brand (justcbdstore.com) and I am currently planning to develop my wholesale side of company. I really hope that anybody at targetdomain can help me . I considered that the best way to accomplish this would be to talk to vape companies and cbd retailers. I was hoping if someone could recommend a qualified site where I can purchase CBD Shops Business Data I am currently checking out creativebeartech.com, theeliquidboutique.co.uk and wowitloveithaveit.com. Unsure which one would be the most suitable option and would appreciate any guidance on this. Or would it be easier for me to scrape my own leads? Ideas?

Responder

Your style is so unique compared to other folks I have read stuff from. I appreciate you for posting when you have the opportunity, Guess I’ll just bookmark this blog.

Responder

It’s hard to come by experienced people for this subject, however, you seem like you know what you’re talking about! Thanks

Responder

I needed to thank you for this fantastic read!! I definitely enjoyed every bit of it. I’ve got you saved as a favorite to look at new stuff you post…

Responder

Greetings! Very useful advice in this particular post! It’s the little changes that make the largest changes. Thanks for sharing!

Responder

Very good info. Lucky me I found your site by accident (stumbleupon). I have book-marked it for later!

Responder

Hello! Someone in my Facebook group shared this website
with us so I came to take a look. I’m definitely loving the information. I’m
book-marking and will be tweeting this to my followers!
Fantastic blog and excellent design. adreamoftrains web hosting companies

Responder

I just want to tell you that I am beginner to blogs and definitely enjoyed your blog site. Likely I’m going to bookmark your website . You certainly come with perfect articles and reviews. With thanks for revealing your web page.

Responder

I simply want to say I am just newbie to blogs and really enjoyed this web-site. More than likely I’m likely to bookmark your website . You really have fantastic well written articles. Thanks a bunch for revealing your web site.

Responder

There is definately a lot to find out about this subject. I like all the points you have made.

Responder

Hello! I just would like to provide a significant thumbs up for the great info you have here on this blog post. I will be returning to your blog for even more quickly.

Responder

pitkävetovihjeet

Responder

KAISERSLUST Plattform der Wiener Sex Scene Sex in Wien – Girls in Wien – Escorte Wien – Transen Wien – Hostessen Wien Escort Wien – Massagen Wien – Studios Wien – Laufhaus und Bordelle Wien Asiatinnen Wien – Sex in Wien – Kaiserslust – Der Kaiser hat Lust – Sex

Responder

“an impresario of expressionism”

Responder

Shop; Unique Functions. Simple Product Layouts. Post with review. Advanced Product Layout. Best conversion pages. Frontend Search · Listing example …

Responder

netticasinot pikakasinot parhaat netticasinot

Responder

I?d have to talk to you right here. Which is not something I generally do! I enjoy checking out a message that will make people assume. Likewise, thanks for enabling me to comment!

Responder

Welcome to iBeautys Best, iBeautys Best is the number one destination for Latest Beauty Products. Here you can easily buy your desired product from all over the world with very reasonable price.

Responder

Good blog post. I find out something much more challenging on different blog sites day-to-day. It will constantly be boosting to read web content from other writers and also exercise a little something from their shop. I?d favor to make use of some with the content on my blog whether you don?t mind. Natually I?ll provide you a link on your web blog. Many thanks for sharing.

Responder

David-Home Northeast is your premier source for all of your Real Estate investing needs. We provide a variety of solutions for sellers looking to sell fast and investors looking to grow their real estate investment portfolios for better returns. At David-Home Northeast, we are dedicated to improving and redeveloping the areas that we operate in. We specialize in helping sellers of distressed properties (single and multi-family homes, commercial, retail, bank REOs, etc.) find buyers looking to invest. Let us put our network of cash home buyers and private money lenders to work for you so you can say “David” to that old unwanted property.

Responder

David-Home Northeast is your premier source for all of your Real Estate investing needs. We provide a variety of solutions for sellers looking to sell fast and investors looking to grow their real estate investment portfolios for better returns. At David-Home Northeast, we are dedicated to improving and redeveloping the areas that we operate in. We specialize in helping sellers of distressed properties (single and multi-family homes, commercial, retail, bank REOs, etc.) find buyers looking to invest. Let us put our network of cash home buyers and private money lenders to work for you so you can say “David” to that old unwanted property.

Responder

Aw, this was a truly wonderful blog post. In idea I would like to place in composing like this furthermore? taking some time and also real initiative to make a great article? however what can I claim? I hesitate alot and never appear to obtain something done.

Responder

Natural Releaf CBD | New York CBD Store with locations in Murray Hill, NY | Upper East Side, NY | White Plains, NY Serving New York City, NY and Westchester, NY High Quality CBD Products With Lab Test

Responder

I seriously love your website.. Very nice colors & theme. Did you make this web site yourself? Please reply back as I’m planning to create my own personal blog and want to know where you got this from or exactly what the theme is named. Appreciate it!

Responder

Love watching sunset !

Responder

Love watching sunset !

Responder

ilmaiset pornovideot, pornovideot, porno videot, pornovideoita, porn videos, free pornvideos, porno video

Responder

Love watching sunset !

Responder

Love watching sunset !

Responder

Best view i have ever seen !

Responder

ilmaiset videot, ilmaiset pornovideot, ilmaiset porno videot, porno video, porno videot

Responder

Excellent blog here! Also your site rather a lot up fast! What web host are you using? Can I get your affiliate link to your host? I wish my site loaded up as fast as yours lol

Responder

I?d have to get in touch with you right here. Which is not something I usually do! I enjoy checking out a blog post that will certainly make people assume. Likewise, thanks for enabling me to comment!

Responder

Temperature Screening

Responder

cbd oil

Responder

You ought to participate in a competition for one of the most effective blog sites online. I will certainly recommend this website!

Responder

Online jewelry boutique specializing in custom gold and silver pieces. For the hippy hearted fashion lover. Known for its custom lotus flower hoop earrings and large collection of hoop earrings. Customers enjoy the classic and unique versatile everyday jewelry designs. Glamour hippy began is also known for its dainty gold jewelry pieces. Bohemian chic styles with modern fashion flare. Great prices and affordable. Everyday pieces to statement piece designs for special occasions. Glamour hippy is inspired by diverse world culture and it reflects into the ever changing designs. Its customer enjoys unique pieces and comfort in style. Glamour hippy wants to be a part of its customers wardrobe for many years and part of great memories where ever the customer takes their jewelry pieces. Glamour hippy is glamour and hippy all in one. Shiny pretty pieces, Unique, Glamorous, boho chic, one of a kind, dainty, but statement worthy.

Responder

netticasinot, netticasino, casino, kasinot, nettkasinot

Responder

extremely nice message, i certainly like this web site, go on it

Responder

GEM-CAR auto repair shop management software is arguably the most comprehensive software of its kind currently available. Lauded for its easy to use modules including CRM, digital inspection and electronic punch clock: it provides the repair shop operator with a complete system to run the business. GEM-CAR puts the shop operator firmly in the driver’s seat. And if you are a fleet operator look for GEM-FLEET our fleet management software.

Responder

Wonderful goods from you, man. I’ve understand your stuff previous to and you are just too great. I really like what you have acquired here, really like what you’re stating and the way in which you say it. You make it entertaining and you still care for to keep it smart. I can not wait to read far more from you. This is really a terrific site.

Responder

As a Newbie, I am permanently searching online for articles that can benefit me. Thank you

Responder

This web site is really a walk-through for all of the information you wanted regarding this and also didn?t recognize that to ask. Glimpse right here, as well as you?ll definitely discover it.

Responder

SHOP ALL BIKE mission is to provide only the finest & high quality Bike Accessories. Products available, backed by fast, efficient and accurate service. SHOP ALL BIKE is committed to doing all of this, and still maintain very competitive pricing

Responder

I have recently started a web site, the info you provide on this website has helped me tremendously. Thank you for all of your time & work.

Responder

pikakasinot, kasinot ilman rekisteröitymistä

Responder

It?s tough to discover educated people on this topic, but you seem like you understand what you?re discussing! Thanks

Responder

cbd oil ny

Responder

I used to be suggested this website by means of my cousin. I’m now not sure whether or not this submit is written by way of him as nobody else realize such specific about my trouble. You are amazing! Thanks!

Responder

Thank you for sharing superb informations. Your website is so cool. I am impressed by the details that you¡¦ve on this blog. It reveals how nicely you understand this subject. Bookmarked this website page, will come back for extra articles. You, my pal, ROCK! I found simply the information I already searched everywhere and just couldn’t come across. What an ideal web-site.

Responder

I simply couldn’t leave your site before suggesting that I actually enjoyed the usual information a person provide in your guests? Is going to be back often in order to check up on new posts.

Responder

los angeles hookup

Responder

This truly answered my trouble, thanks!

Responder

buy prescription drugs online

Responder

I haven’t checked in here for some time since I thought it was getting boring, but the last few posts are good quality so I guess I will add you back to my everyday bloglist. You deserve it my friend 🙂

Responder

My brother suggested I might like this web site. He was entirely right. This post truly made my day. You cann’t imagine just how much time I had spent for this information! Thanks!

Responder

An excellent share, I simply offered this onto an associate who was doing a little evaluation on this. And he as a matter of fact bought me morning meal due to the fact that I located it for him. smile. So let me reword that: Thnx for the treat! But yeah Thnkx for spending the moment to discuss this, I feel highly about it and enjoy learning more on this subject. When possible, as you become experience, would certainly you mind upgrading your blog site with even more details? It is very useful for me. Huge thumb up for this post!

Responder

what is dissertation writing https://dissertationaas.com/ – dissertation assistance writing best dissertation service what is a dissertation dissertation phd

Responder

cheap essay help https://essayhelptopp.com/ – essay 123 help need help writing an essay college essay writing help i need help writing an argumentative essay

Responder

I couldn’t refrain from commenting. Well written!

Responder

college essay review services https://essaywritingservicenews.com/ – essay writing services scams college essay services essays on community service essay paper writing service

Responder

The next time I review a blog site, I really hope that it does not dissatisfy me as high as this one. I mean, I recognize it was my selection to check out, but I really thought youd have something fascinating to claim. All I listen to is a number of grumbling about something that you could deal with if you werent too hectic looking for interest.

Responder

pay for paper https://papersonlinesfy.com/ – write my math paper how to find someone to write my paper write my paper for cheap help with filing divorce papers

Responder

I’m still learning from you, while I’m making my way to the top as well. I absolutely liked reading all that is posted on your website.Keep the aarticles coming. I liked it!

Responder

professional college essay writers https://essaywriterdodo.com/ – college essay writer professional college essay writers essay writer program essay writers review

Responder

persuasive essay writing help https://essaywriterslop.com/ – best college essay writing services help me write a narrative essay essay writing services scams help write essay online

Responder

my custom essay https://customessayjojo.com/ – essay custom custom essay writing canada custom essay writing cheap best custom essay writers

Responder

п»їthesis https://termpaperlow.com/ – choosing a thesis topic help writing a thesis statement thesis services thesis online

Responder

order custom essays https://essayonlinehdb.com/ – custom essays no plagiarism write my essay for money custom essay writing company essay writing website reviews

Responder

do my coursework online https://courseworkhelpvra.com/ – courseworks help cpa coursework custom coursework writing service coursework writing service uk

Responder

I’m not sure exactly why but this weblog is loading incredibly slow for me. Is anyone else having this problem or is it a problem on my end? I’ll check back later and see if the problem still exists.

Responder

netticasinot, parhaat netticasinot, netticasino

Responder

viagra brand name http://60lmentop.com/ – buy generic viagra online pharmacy viagra viagra pill viagra online without prescription

Responder

Would certainly you be fascinated in trading links?

Responder

cialis daily http://aazmencial.com/ – cialis 10mg tadalafil citrate cialis tadalafil cialis without prescription

Responder

Outstanding post but I was wanting to know if you could write a litte more on this subject? I’d be very grateful if you could elaborate a little bit further. Kudos!

Responder

F*ckin’ amazing things here. I am very glad to see your article. Thanks a lot and i am looking forward to contact you. Will you please drop me a mail?

Responder

Hi, I do believe this is an excellent site. I stumbledupon it 😉 I’m going to return yet again since i have saved as a favorite it. Money and freedom is the best way to change, may you be rich and continue to guide others.

Responder

Things i don’t understood is the simple truth is how you’re not actually
much more smartly-preferred than you may be right
now. You will be very intelligent. You realize thus considerably pertaining to this matter, produced me
for my part consider it from numerous numerous angles.
Its like women and men aren’t fascinated unless it is something to accomplish with Lady gaga!
Your own stuffs excellent. All the time maintain it!

Take a look at my web site JudieUSemo

Responder

Site Rank Services offers affordable premium SEO packages & helps increase the visibility of your site in the search engines. We help you generate more profits

Responder

I’ve learn some just right stuff here. Certainly worth bookmarking for revisiting. I wonder how a lot attempt you set to make this sort of excellent informative web site.

Responder

online payday loans no credit check https://sapaydayiloans.com/ – payday loans for bad credit payday advance loans payday advance loans online payday loans texas

Responder

cialis 20 mg http://50cialmen.com/ – cialis without prescription cialis tadalafil tadalafil online cialis reviews

Responder

Shopify fitness store

Responder

Hi, I do think this is an excellent blog. I stumbledupon it 😉 I will revisit once again since i have book marked it. Money and freedom is the best way to change, may you be rich and continue to guide other people.

Responder

Everything is very open with a very clear explanation of the issues. It was truly informative. Your website is useful. Many thanks for sharing!

Responder

online order viagra http://45menvia.com/ – viagra generic brand canadian viagra viagra pill buy viagra no prescription

Responder

This blog was… how do you say it? Relevant!! Finally I have found something which helped me. Many thanks!

Responder

I enjoy looking through an article that can make people think. Also, thank you for allowing for me to comment!

Responder

adult toys near me ,where to buy adult toys near me,male sex toys,gay male sex toys,best gay male sex toys,female sex toys,best female sex toys,homemade female sex toys,female adult toys,female masturbation toys,diy female sex toys,female pleasure toys,female transformers toys,female masturbation with toys,

Responder

I am really impressed with your writing skills as well as with the layout on your blog. Is this a paid theme or did you modify it yourself? Either way keep up the nice quality writing, it’s rare to see a nice blog like this one nowadays..

Responder

Today, I went to the beachfront with my kids. I found a sea shell and gave it to my 4 year old daughter and said «You can hear the ocean if you put this to your ear.» She placed the shell to her ear and screamed. There was a hermit crab inside and it pinched her ear. She never wants to go back! LoL I know this is totally off topic but I had to tell someone!

Responder

Aw, this was an exceptionally good post. Finding the time and actual effort to produce a very good article… but what can I say… I hesitate a whole lot and never seem to get anything done.

Responder

buy essay writing http://buycildjea.com/ – where can i buy essays online buy essays buy essay online safe buying essays online

Responder

I found your blog website on google as well as inspect a few of your early messages. Continue to maintain the excellent run. I simply extra up your RSS feed to my MSN Information Visitor. Looking for onward to learning more from you in the future!?

Responder

An interesting discussion is worth comment. I think that you ought to write more on this subject, it might not be a taboo matter but typically folks don’t talk about such issues. To the next! All the best!!

Responder

I just couldn’t depart your site before suggesting that I really enjoyed the standard information a person provide for your visitors? Is gonna be back often to check up on new posts

Responder

custom essays toronto http://viagranerrds.com/ – custom essay writing reviews custom essays custom essay writers cheap custom essay

Responder

I could not refrain from commenting. Exceptionally well written!

Responder

Definitely believe that which you said. Your favorite reason appeared to be on the web the simplest thing to be aware of. I say to you, I certainly get irked while people consider worries that they just do not know about. You managed to hit the nail upon the top and defined out the whole thing without having side effect , people could take a signal. Will probably be back to get more. Thanks|

Responder

custom essay writing service org http://viagrapfhze.com/ – best cheap essay writing service online essay writing services essays about community service college essay community service

Responder

in an essay help you guide http://buyjeacialonline.com/ – essay about the help essay about the help english essay help nursing essay help

Responder

Happy Faces We are up to standard with our products and services.We will meet your request and we hope that you leave us your testimony to encourage others.

Responder

Someone essentially help to make severely posts I might state. That is the very first time I frequented your website page and so far? I amazed with the research you made to create this actual publish extraordinary. Fantastic process!

Responder

Newborn Kids baby girls clothes

Responder

Aw, this was a really nice post. Taking a few minutes and actual effort to make a very good article… but what can I say… I procrastinate a lot and don’t manage to get anything done.

Responder

I was able to find good info from your content.

Responder

how to recover bitcoin sent to wrong address

Responder

This design is wicked! You obviously know how to keep a reader amused. Between your wit and your videos, I was almost moved to start my own blog (well, almost…HaHa!) Excellent job. I really enjoyed what you had to say, and more than that, how you presented it. Too cool!

Responder

My wife and i were absolutely fulfilled that Albert could finish off his investigations with the ideas he made from your web pages. It is now and again perplexing to just happen to be offering methods that some other people could have been trying to sell. And we all know we’ve got the blog owner to give thanks to because of that. The type of illustrations you have made, the straightforward web site navigation, the friendships you can aid to promote – it is all excellent, and it’s really helping our son in addition to the family understand the theme is pleasurable, which is very fundamental. Thanks for all!

Responder

tadalafil tablets 20 mg http://hyivglazcial.com/ http://hyivglazcial.com/ buy cheap cialis

Responder

Lindsay Preston is a multi-certified life coach for go-getter women who have good lives but want great lives.

Responder

how long does it take for cialis to work http://joicialviaed.com/ http://joicialviaed.com/ cialis for daily use

Responder

buy tadalafil 20mg price http://ciallaled.com/ http://ciallaled.com/ online cialis

Responder

cialis daily http://cigened.com/ http://cigened.com/ cialis 20 mg

Responder

Nice post. I was checking continuously this blog and I’m impressed! Very useful information particularly the last part 🙂 I care for such info a lot. I was looking for this particular info for a long time. Thank you and best of luck.

Responder

I have seen many useful elements on your website about pc’s. However, I have the viewpoint that laptops are still less than powerful more than enough to be a wise decision if you generally do projects that require plenty of power, for example video enhancing. But for internet surfing, word processing, and quite a few other frequent computer work they are perfectly, provided you never mind the little screen size. Many thanks for sharing your opinions.

Responder

best place to buy viagra online http://menjojil.com/ http://menjojil.com/ over the counter viagra substitute walgreens

Responder

how much is viagra http://60lmentop.com/ http://60lmentop.com/ viagra pill

Responder

canadian pharmacy viagra http://45menvia.com/ http://45menvia.com/ does viagra work

Responder

buy cialis http://aazmencial.com/ http://aazmencial.com/ generic cialis cost

Responder

canadian viagra http://viamengo.com/ http://viamengo.com/ is viagra covered by insurance

Responder

tadalafil best price http://hyitebeviag.com/ http://hyitebeviag.com/ cialis for sale

Responder

Simple & Powerful Uploadea is Amazingly easy to Use where to Store Your Data & Save Your Countless Time

Responder

cialis dose http://mencialed.com/ http://mencialed.com/ cialis daily

Responder

You made some decent points there. I looked on the net for more information about the issue and found most people will go along with your views on this web site.

Responder

womens viagra http://didoviamen.com/ http://didoviamen.com/ viagra generic name

Responder

I have been exploring for a bit for any high-quality articles or blog posts on this kind of space . Exploring in Yahoo I at last stumbled upon this site. Studying this info So i’m glad to express that I’ve a very just right uncanny feeling I came upon just what I needed. I most for sure will make certain to do not overlook this site and provides it a look on a constant basis.

Responder