Saltar al contenido
PROGRAMAR EN VBA MACROS DE EXCEL

Formato Negrita solo a Mayúsculas

Este procedimiento de VBA o macro de Excel, recorre todas las filas mientras no estén, en caso de encontrar una cadena de texto en Mayúscula le da formato negrita, una vez recorrida hasta la última fila de la columna, pasa a la columna siguiente y así hasta la última columna con datos del ahoja de Excel,  haz click en el link del final para bajar el ejemplo. Te recomiendo que leas un excelente libro sobre Excel para ello haz click acá. El código que se encuentra a continuación se debe ingresar en un módulo, descargando el ejemplo lo podrás ver en funcionamiento, analizar, modificar y adaptar a lo que tú estés realizando el código está abierto sin ningún tipo de restricción.

Código a insertar en módulo

Sub NegritaaMayuscula()
Dim cadena As String
Dim fila, col As Integer
fila = 2
col = 1
While Sheets(«hoja1»).Cells(fila, col) <> Empty
  
   While Sheets(«hoja1»).Cells(fila, col) <> Empty
       cadena = Sheets(«hoja1»).Cells(fila, col)
     If UCase(cadena) = cadena Then
        Cells(fila, col).Select
        Selection.Font.Bold = True
     End If
   fila = fila + 1
Wend
fila = 2
col = col + 1
Wend
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 am the business owner of JustCBD brand (justcbdstore.com) and am trying to broaden my wholesale side of company. I am hoping someone at targetdomain can help me 🙂 I considered that the most ideal way to do this would be to connect to vape companies and cbd retailers. I was hoping if someone could recommend a trusted website where I can purchase CBD Shops B2B Email Marketing List I am already taking a look at creativebeartech.com, theeliquidboutique.co.uk and wowitloveithaveit.com. Not exactly sure which one would be the most suitable solution and would appreciate any guidance on this. Or would it be simpler for me to scrape my own leads? Ideas?

Responder

After exploring a few of the articles on your web site, I seriously appreciate your way of blogging. I saved it to my bookmark webpage list and will be checking back soon. Please check out my web site as well and tell me how you feel.

Responder

Everything is very open with a really clear explanation of the issues. It was really informative. Your site is very helpful. Thank you for sharing!

Responder

There is certainly a lot to learn about this issue. I really like all the points you have made.

Responder

You have made some really good points there. I checked on the internet to learn more about the issue and found most people will go along with your views on this website.

Responder

It’s enormous that you are getting ideas from this paragraph as well as from our discussion made here.
adreamoftrains best web hosting sites

Responder

I just want to tell you that I am all new to blogging and certainly enjoyed this web blog. More than likely I’m likely to bookmark your website . You absolutely come with fabulous writings. Regards for sharing with us your website.

Responder

Very good write-up. I absolutely love this site. Stick with it!

Responder

This is a topic that’s near to my heart… Many thanks! Exactly where are your contact details though?

Responder

You are so interesting! I do not think I have read through a single thing like this before. So nice to find another person with genuine thoughts on this subject. Seriously.. many thanks for starting this up. This site is one thing that is required on the internet, someone with some originality!

Responder

Your style is so unique in comparison to other people I have read stuff from. Many thanks for posting when you’ve got the opportunity, Guess I’ll just bookmark this web site.

Responder

Hi! I just want to give you a huge thumbs up for the excellent info you have here on this post. I will be returning to your site for more soon.

Responder

Wonderful article! We are linking to this great article on our site. Keep up the good writing.

Responder

Aw, this was an exceptionally nice post. Spending some time and actual effort to make a great article… but what can I say… I put things off a whole lot and never seem to get nearly anything done.

Responder

Achieving your fitness goal does not need a certified personal trainer or an expensive gym membership, especially if you have the budget and the space to consider practically every workout machine on the market.

Responder

I don’t even know how I ended up here, but I thought this post was great.
I don’t know who you are but certainly you are going
to a famous blogger if you aren’t already 😉
Cheers! cheap flights 31muvXS

Responder

Hello there! This article couldn’t be written any better! Looking at this post reminds me of my previous roommate! He always kept preaching about this. I’ll forward this post to him. Fairly certain he’s going to have a great read. Many thanks for sharing!

Responder

I would like to thank you for the efforts you’ve put in penning this site. I am hoping to view the same high-grade content from you later on as well. In truth, your creative writing abilities has inspired me to get my own blog now 😉

Responder

Good site you have here.. It’s difficult to find high-quality writing like yours
nowadays. I truly appreciate individuals like you! Take care!!
cheap flights 3gqLYTc

Responder

Aw, this was a very good post. Taking the time and actual effort to generate a top notch article… but what can I say… I put things off a lot and never manage to get anything done.

Responder

This is the perfect webpage for anybody who hopes to find out about this topic. You realize so much its almost hard to argue with you (not that I actually would want to…HaHa). You definitely put a new spin on a topic that’s been written about for decades. Wonderful stuff, just excellent!

Responder

An impressive share! I have just forwarded this onto a co-worker who had been doing a little research on this. And he in fact ordered me lunch because I stumbled upon it for him… lol. So let me reword this…. Thank YOU for the meal!! But yeah, thanx for spending time to discuss this topic here on your web page.

Responder

That is a great tip especially to those new to the blogosphere. Simple but very precise info… Appreciate your sharing this one. A must read article!

Responder

Pretty! This has been an extremely wonderful article. Thanks for providing these details.

Responder

If some one needs expert view on the topic of blogging after that i advise him/her to pay a visit this blog, Keep up
the pleasant work.

Responder

What’s up it’s me, I am also visiting this web page regularly, this website is in fact good
and the users are genuinely sharing pleasant thoughts.

Responder

You made some really good points there. I checked on the web to learn more about the issue and found most individuals will go along with your views on this site.

Responder

Formato Negrita solo a Mayúsculas – PROGRAMAR EN VBA MACROS DE EXCEL
xrebkzjdh http://www.gj92s828u5397c8aywproh9xl7k175l8s.org/
[url=http://www.gj92s828u5397c8aywproh9xl7k175l8s.org/]uxrebkzjdh[/url]
axrebkzjdh

Responder

I like the helpful info you provide in your articles.
I will bookmark your blog and check again here frequently. I am quite sure
I’ll learn lots of new stuff right here! Good luck for the next!

Responder

We tested coffee makers for the water temperature during the brew cycle and the brewing time as well as the temperature of the coffee at the end of brewing and during the keep warm cycle. In addition, we evaluated each brewer’s ease of use, including how easy it was to read and use the controls, access the water tank and brew basket, read the markings on the tank and carafe, whether or not it had automatic keep warm and shut off cycles, and the ease of cleaning the carafe.

Responder

I have to thank you for the efforts you’ve put in penning this site. I’m hoping to check out the same high-grade content by you in the future as well. In truth, your creative writing abilities has inspired me to get my very own blog now 😉

Responder

Spot on with this write-up, I honestly think this web site needs much more attention. I’ll probably be returning to read through more, thanks for the advice!

Responder

This website was… how do I say it? Relevant!! Finally I’ve found something which helped me. Appreciate it!

Responder

After I initially left a comment I appear to have clicked on the -Notify me when new comments are added- checkbox and now whenever a comment is added I get four emails with the exact same comment. Is there a way you are able to remove me from that service? Kudos!

Responder

An outstanding share! I have just forwarded this onto a coworker who had been doing a little research on this. And he in fact bought me dinner due to the fact that I found it for him… lol. So let me reword this…. Thanks for the meal!! But yeah, thanks for spending some time to discuss this topic here on your site.

Responder

Hi! I could have sworn I’ve been to your blog before but after browsing through many of the articles I realized it’s new to me. Anyhow, I’m certainly happy I stumbled upon it and I’ll be book-marking it and checking back often!

Responder

That is a really good tip especially to those fresh to the blogosphere. Short but very accurate information… Appreciate your sharing this one. A must read post!

Responder

Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point. You definitely know what youre talking about, why waste your intelligence on just posting videos to your weblog when you could be giving us something informative to read?

Responder

Wow, this paragraph is good, my younger sister is analyzing such
things, so I am going to tell her.

Responder

This website was… how do I say it? Relevant!! Finally I’ve found something which helped me. Thanks a lot!

Responder

Right here is the right webpage for anyone who really wants to find out about this topic. You know so much its almost hard to argue with you (not that I actually would want to…HaHa). You certainly put a fresh spin on a subject that’s been discussed for many years. Great stuff, just excellent!

Responder

The very next time I read a blog, Hopefully it won’t disappoint me just as much as this one. After all, Yes, it was my choice to read, but I actually believed you would have something interesting to say. All I hear is a bunch of complaining about something you could fix if you weren’t too busy searching for attention.

Responder

hello!,I like your writing very much! share we communicate more about your article on AOL? I need an expert on this area to solve my problem. May be that’s you! Looking forward to see you.

Responder

Is this a paid subject matter or did youu modify it your self?

Responder

Youre so cool! I dont suppose Ive read something like this before. So nice to search out any person with some original ideas on this subject. realy thank you for starting this up. this website is one thing that is wanted on the internet, someone with somewhat originality. helpful job for bringing something new to the web!

Responder

As I site possessor I believe the content matter here is rattling wonderful , appreciate it for your hard work. You should keep it up forever! Good Luck.

Responder

Heb 13:5: Keep your lives free from the love of money and be content with what you have, because God has said, “Never will I leave you; never will I forsake you.”

Responder

Aw, this was an extremely good post. Taking a few minutes and actual effort to generate a superb article… but what can I say… I hesitate a lot and don’t seem to get nearly anything done.

Responder

It’s laborious to find knowledgeable folks on this topic, however you sound like you already know what you’re talking about! Thanks

Responder

Nice post. I learn something new and challenging on sites I stumbleupon on a daily basis. It will always be interesting to read through content from other authors and practice something from other sites.

Responder

Aw, this was an extremely good post. Taking the time and actual effort to make a top notch article… but what can I say… I hesitate a whole lot and don’t seem to get anything done.

Responder

Good article! We are linking to this particularly great article on our website. Keep up the great writing.

Responder

I am always looking online for posts that can aid me. Thanks!

Responder

Howdy! This blog post couldn’t be written much better! Going through this article reminds me of my previous roommate! He constantly kept preaching about this. I will send this information to him. Fairly certain he’s going to have a good read. Thank you for sharing!

Responder

It’s simple, yet effective. A lot of times it’s very hard to get that «perfect balance» between superb usability and visual appearance.

Responder

Howdy! I could have sworn I’ve been to your blog before but after looking at many of the posts I realized it’s new to me. Anyways, I’m certainly delighted I stumbled upon it and I’ll be bookmarking it and checking back often!

Responder

Next time I read a blog, Hopefully it won’t disappoint me as much as this particular one. After all, I know it was my choice to read, however I really believed you would have something useful to say. All I hear is a bunch of complaining about something you can fix if you were not too busy searching for attention.

Responder

Good post. I absolutely appreciate this site. Thanks!

Responder

Hi, I do think this is an excellent blog. I stumbledupon it 😉 I may return yet again since i have saved as a favorite it. Money and freedom is the greatest way to change, may you be rich and continue to guide other people.

Responder

Thanks , I have recently been searching for info approximately this topic for a while and yours is the best I’ve found out so far. But, what about the bottom line? Are you positive concerning the supply?

Responder

I like it when people get together and share views. Great site, continue the good work!

Responder

very nice submit, i actually love this website, carry on it

Responder

It’s onerous to find educated folks on this topic, but you sound like you understand what you’re speaking about! Thanks

Responder

Spot on with this write-up, I truly believe this website needs far more attention. I’ll probably be returning to read through more, thanks for the information!

Responder

Good day! I could have sworn I’ve visited this web site before but after browsing through many of the posts I realized it’s new to me. Anyhow, I’m definitely pleased I discovered it and I’ll be book-marking it and checking back frequently!

Responder

It’s really a nice and helpful piece of info. I am glad that you shared this useful info with us. Please keep us informed like this. Thanks for sharing.

Responder

I blog quite often and I seriously thank you for your content. This article has truly peaked my interest. I am going to bookmark your blog and keep checking for new information about once a week. I opted in for your Feed as well.

Responder

Simply a smiling visitor here to share the love (:, btw outstanding layout.

Responder

Aw, this was a very nice post. Spending some time and actual effort to make a top notch article… but what can I say… I put things off a whole lot and don’t manage to get anything done.

Responder

You need to take part in a contest for one of the greatest sites on the net. I’m going to recommend this site!

Responder

Somebody essentially help to make seriously posts I would state. This is the first time I frequented your web page and thus far? I surprised with the research you made to make this particular publish incredible. Wonderful job!

Responder

We absolutely love your blog and find almost all of your post’s to be precisely what I’m looking for. Does one offer guest writers to write content to suit your needs? I wouldn’t mind creating a post or elaborating on a lot of the subjects you write about here. Again, awesome site!

Responder

Hi there, just became alert to your blog through Google, and found that it is really informative. IĂ­m gonna watch out for brussels. IĂ­ll be grateful if you continue this in future. Lots of people will be benefited from your writing. Cheers!

Responder

Excellent post. I certainly appreciate this website. Keep it up!

Responder

Very good article! We are linking to this great content on our site. Keep up the great writing.

Responder

Hello, There’s no doubt that your web site could be having web browser compatibility issues. When I look at your web site in Safari, it looks fine however, when opening in Internet Explorer, it’s got some overlapping issues. I just wanted to provide you with a quick heads up! Apart from that, excellent website!

Responder

Extraordinary job here. I in truth loved what you had to state.

Responder

Great web site you have here.. It’s difficult to find excellent writing like yours nowadays. I really appreciate people like you! Take care!!

Responder

GScraper

Responder

Great post. I was checking continuously this blog and I’m inspired! Very helpful info specifically the final section 🙂 I handle such info much. I was seeking this particular information for a very lengthy time. Thank you and good luck.

Responder

I’m still learning from you, as I’m trying to reach my goals. I definitely love reading everything that is written on your blog.Keep the stories coming. I loved it!

Responder

Hi there! I could have sworn I’ve visited this blog before but after browsing through a few of the articles I realized it’s new to me. Anyways, I’m definitely pleased I stumbled upon it and I’ll be bookmarking it and checking back often!

Responder

Everyone loves what you guys are up too. This sort of clever work and coverage! Keep up the terrific works guys I’ve included you guys to blogroll.

Responder

Have you ever considered about including a little bit more than just your articles? I mean, what you say is fundamental and all. However think of if you added some great photos or video clips to give your posts more, «pop»! Your content is excellent but with images and clips, this website could certainly be one of the most beneficial in its niche. Wonderful blog!

Responder

You could certainly see your enthusiasm in the work you write. The world hopes for more passionate writers like you who aren’t afraid to say how they believe. Always go after your heart.

Responder

You should take part in a contest for one of the highest quality blogs on the web. I will recommend this website!

Responder

You’re so awesome! I don’t believe I’ve read a single thing like that before. So nice to discover another person with genuine thoughts on this subject matter. Seriously.. many thanks for starting this up. This website is one thing that is required on the internet, someone with a little originality!

Responder

ART

Responder

you have a very excellent weblog here! want to earn some invite posts on my blog?

Responder

I blog quite often and I truly thank you for your information. This article has really peaked my interest. I’m going to take a note of your blog and keep checking for new information about once per week. I subscribed to your Feed too.

Responder

I enjoyed reading your pleasant site. I see you offer priceless information. feel into this site by chance but I’m sure glad I clicked on that link. You definitely answered all the questions I’ve been dying to answer for some time now. Will definitely come back for more of this.

Responder

Nice post. I learn something totally new and challenging on websites I stumbleupon everyday. It’s always useful to read through content from other writers and use something from their web sites.

Responder

I will immediately grab your rss as I can not find your e-mail subscription link or newsletter service. Do you’ve any? Kindly let me know in order that I could subscribe. Thanks.

Responder

Generally I do not read post on blogs, however I wish to say that this write-up very compelled me to take a look at and do it! Your writing taste has been surprised me. Thanks, very nice article.

Responder

I could not resist commenting. Exceptionally well written!

Responder

bookmarked!!, I like your web site!

Responder

Hi my friend! I want to say that this post is awesome, great written and include almost all significant infos. I’d like to see extra posts like this .

Responder

Have you thought about including certain movies in your – Gulvafslibning | Kurt Gulvmand write-up We think it might strengthen some of our comprehension Thanks ! Los Angeles Web Designer

Responder

I wanted to thank you for this very good read!! I absolutely loved every bit of it. I’ve got you book marked to look at new things you post…

Responder

some sleeping bags are waterproof and weatherproof too, they are nice for camping outside the house**

Responder

Hi there! I just want to offer you a huge thumbs up for your great info you have got here on this post. I will be returning to your site for more soon.

Responder

Hi, i think that i saw you visited my web site thus i came to “return the favor”.I’m attempting to find things to enhance my website!I suppose its ok to use a few of your ideas!!

Responder

An impressive share, I simply given this onto a colleague who was doing somewhat evaluation on this. And he actually bought me breakfast as a result of I discovered it for him.. smile. So let me reword that: Thnx for the deal with! However yeah Thnkx for spending the time to discuss this, I feel strongly about it and love studying extra on this topic. If potential, as you turn into experience, would you thoughts updating your blog with more particulars? It is highly helpful for me. Large thumb up for this weblog submit!

Responder

Everything is very open with a very clear description of the challenges. It was definitely informative. Your website is very useful. Thanks for sharing!

Responder

Having read this I believed it was rather informative. I appreciate you spending some time and effort to put this informative article together. I once again find myself personally spending way too much time both reading and leaving comments. But so what, it was still worth it!

Responder

I discovered your weblog web site on google and check a few of your early posts. Continue to keep up the superb operate. I just additional up your RSS feed to my MSN Information Reader. Seeking ahead to studying extra from you in a while!…

Responder

Yesterday, while I was at work, my cousin stole my apple ipad and tested to see if it can survive a 25 foot drop, just so she can be a youtube sensation. My iPad is now broken and she has 83 views. I know this is entirely off topic but I had to share it with someone!

Responder

Valuable info. Lucky me I found your website by accident, and I am shocked why this accident did not happened earlier! I bookmarked it.

Responder

hey there and thank you for your information – I’ve definitely picked up something new from right here. I did however expertise several technical points using this website, as I experienced to reload the web site lots of times previous to I could get it to load properly. I had been wondering if your web host is OK? Not that I am complaining, but slow loading instances times will often affect your placement in google and can damage your quality score if advertising and marketing with Adwords. Anyway I’m adding this RSS to my e-mail and could look out for much more of your respective interesting content. Make sure you update this again very soon..

Responder

Hello there! This article couldn’t be written much better! Looking through this article reminds me of my previous roommate! He constantly kept preaching about this. I most certainly will send this information to him. Fairly certain he’s going to have a good read. Thanks for sharing!

Responder

I’m usually to running a blog and i really admire your content. The article has actually peaks my interest. I am going to bookmark your web site and preserve checking for new information.

Responder

A fascinating discussion is definitely worth comment. I do think that you ought to write more on this issue, it may not be a taboo matter but generally people don’t discuss such subjects. To the next! All the best!!

Responder

Wonderful post! We are linking to this particularly great article on our website. Keep up the great writing.

Responder

Great paintings! That is the kind of information that should be shared around the web. Disgrace on Google for no longer positioning this post upper! Come on over and seek advice from my web site . Thanks =)

Responder

Your place is valueble for me. Thanks!…

Responder