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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.