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!

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

Search results for query: *

  • Users: Forrest77
  • Content: Threads
  • Order by date
  1. Forrest77

    Visual Basic in Excel to set active printer preferences

    I know how to select whatever printer I want in excel to print. However, some of my excel sheets require a different paper size. So is there a way to set printer preferences using vb code in excel. I tried to record a Macro selecting the printer, selecting printer properties, selecting...
  2. Forrest77

    Two PC's; Same Wireless Internet Connection, Different Download Speeds

    I have a two pc's connecting to the internet through a wireless router. Both computers show the same speed when tested using SpeakEasy test site. Speakeasy shows a 2mb download speed & 800kb upload speed. However when actually downloading a file from the same site but not speakeasy, the older...
  3. Forrest77

    Is there a way to select the cell in the adjacent column

    Maybe I am going about this wrong. What I have so far is the following that was provided by this site on an earlier question. Dim r As Range 'right oneFor Each r In Range([b12], [b12].End(xlDown)) For Each r In Range([b12], [b12].End(xlDown)) Range(r, r.Offset(0, 4)).Copy [s30] Range(r...
  4. Forrest77

    Having trouble with some excel VB code to move from row to row

    First of all thanks for taking a look because this is way beyond my scope. I have about 50+ rows of excel data of a length from A thru F. I want to copy each row one at a time to say r30 to w30, perform some if/then statements that are working for me, and then print a sheet2 which has a lot...
  5. Forrest77

    Is there a way to select a network printer before Userform1.Printform

    In My Excel Application, I have various Userforms that will need to be printed from different network printers. The printer I need to select is a network label printer. I have looked all over this site and others for some example that I can tweak to my needs but thus far have come up with...
  6. Forrest77

    Trying IF/Then to pick out individual letters in a cell?

    I have a cells that have a combination of letters like "EGM". I have been trying to make and If/Then that if the cell contains an "E", then I will ask it to copy and paste some cells. So far all I have is: If Sheet1.Range("b12:b12") = "=E" Then GoTo line1 Else GoTo line2 line1...
  7. Forrest77

    Want to Select and Cut the Next Non Empty Cell in a Column

    To begin Thank You for any and all help. I am very weak at this. I want to put some code into a command button that when clicked will go to a Column on my excel sheet, select and cut the next available cell with data (skipping over the empty cells) and paste it into a different cell...
  8. Forrest77

    Is there an easy way to set folder pemissions for many users?

    I have a shared folder on a file server that allows all users to see the folder and all the subfolders of the individual clients. However each active directory user\client has a folder named after their login name inside this main shared folder. Is there a way to set permissions or security so...
  9. Forrest77

    Cannot view mail in Outlook Web Access

    I have a user who access her mail through outlook web access OWA when she is home. When she recieves a message she is able to read it as long as it is new and has not been open but if she then closes OWA and goes back in the message is no longer visable. I thought it might be in the OWA page of...

Part and Inventory Search

Back
Top