Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by AJPic

  1. AJPic

    Wireless router problem accessing the Internet with 2 laptops

    Thank you Chris. Is there any literature on the Web that you can point me to on how to do this? Or if it's not too cumbersome, could you possibly explain it yourself? Thanks again. AJ
  2. AJPic

    losing connection to webpages but not poker sites or IM

    I currently have a Linksys wireless router and Comcast cable internet. When I first sign onto my laptop, (w/internal wireless card) the internet usually works fine. I can log onto say PokerStars, fire up some tables and get an internet browser going with no problem. But after about 15 minutes...
  3. AJPic

    losing connection to webpages but not poker sites or IM

    I currently have a Linksys wireless router and Comcast cable internet. When I first sign onto my laptop, (w/internal wireless card) the internet usually works fine. I can log onto say PokerStars, fire up some tables and get an internet browser going with no problem. But after about 15 minutes...
  4. AJPic

    Wireless router problem accessing the Internet with 2 laptops

    Hi, I currently have a Linksys Wireless Router (WRT54GS) and connect to Comcast Cable as my Internet provider. About 8 months ago, I was using 2 Dell Inspiron Laptops, one “OLD machine” with an external (Linksys) Wireless card and one “NEW machine” with an internal card. At that time I was...
  5. AJPic

    Displaying data from an object range

    Thanks for your help guys. It looks like I have a great start to my code.
  6. AJPic

    Displaying data from an object range

    I'm trying to do too much over here and completely botched my last post. I actually do want the Union, not the Intersection. In column C, I'd like to see (Joe, Mark, Tom, Sue, Sarah, Betty). Sorry for the confusion and thank you for your time.
  7. AJPic

    Displaying data from an object range

    Well, to be honest, I'm not sure I need to use Union - I just thought it would return what I needed. What I want to do is take the list from column A: (Joe, Mark, Tom, Sue) and my list from column B: (Mark, Sarah, Betty, Tom) and column C display the union: (Mark, Tom). Perhaps I'm going...
  8. AJPic

    Displaying data from an object range

    First let me say that I'm very novice to VBA and I only use it occasionally. Anyway, I have 2 lists in separate columns of Excel and I'd like to take the union of those 2 lists and display the union in a 3rd column. How can I do this? I started with the following code but am not sure where to...
  9. AJPic

    Formatting text to bold from Excel and sending Email

    Got it guys. Thanks...
  10. AJPic

    Formatting text to bold from Excel and sending Email

    Yes, I am sending the email via Outlook. But I can't quite get it to come out right using your idea. So if this is my quote, "You need to run fast to win the race." and I wanted "fast" to appear in bold, how exactly would my VBA line look? Like this?: EmailBody = "You need to run <b>fast</b>...
  11. AJPic

    Formatting text to bold from Excel and sending Email

    Hi, I'm not really a full blown programmer, so take it easy on me. I have a macro in Excel where I'm sending out a mass emailing. Part of the body of the text needs to be in bold and there are numerous variables throughout the body. How can I format the the portions of the text in VBA to be...
See more

Part and Inventory Search

Back
Top