Search results for query: *

I need to print the first worksheet of every workbook on a network drive. I have gotten this far. Private Sub PrintFiles() Dim i As Long Dim WB As Workbook Application.ScreenUpdating = False With Application.FileSearch .NewSearch .LookIn = "P:\MiniMonthlies\fairpoint" .SearchSubFolders = False...

I am trying to print each change in a validation list by using the following code; CODE Sub Print_all() ActiveSheet.PrintOut For Each c In Range("names") [J5] = C.Value ActiveSheet.PrintOut Next End Sub When I attempt to run the code I am getting the following errors; un-time error 1004...

I am trying to print each change in a validation list by using the following code; Sub Print_all() ActiveSheet.PrintOut For Each c In Range("names") [J5] = Change.Value ActiveSheet.PrintOut Next End Sub When I attempt to run the code I am getting the following errors; un-time error 1004...

I have a spread sheet that has several cells filled with different colors. Is tehre a way to search for a color and replace it with another? Thanks, Wray

I have a form that has a validation list, when I change the value in the validation list it changes many other values on the form. Currently I am having to go through and print these one by one. How would I go about printing these automatically? Thanks, Wray

I have a form that has a validation list, when I change the value in the validation list it changes many other values on the form. Currently I am having to go through and print these one by one. How would I go about printing these automatically? Thanks, Wray

Been a long time since I have been here and I still have not improved in VBA. Anyway I have some data that is not formated Excel friendly. It looks like below; From: 04/19/06 IEX TotalV iew Detail and Summary To: 04/19/06 Sprint C MG...

I know this is not a VBA formula but I have alwyas got my most difficult questions here. Been a long time since I have been here and I still have not improved in VBA. Anyway I have some data that is not formated Excel friendly. It looks like below; From: 04/19/06 IEX TotalV iew...

Hello all, Have'nt been here in awhile. Not sure if this is even possible, if it is I know it will be VB, but; Is there any way to link the sheet names to a particular cell that if that cell is changed it will change the sheet tab name? Looking forward to your help. Wray

Hello All, Not sure where to start with this one. What I have is a List of managers in Column A, B has an employees name, C if they are full time or part time, D thru AH each repersents a day of the month (1-31) with either a 1.0 or a .5 in each row under them repersenting if they where full or...

Hello All, Im using the following code to delete rows from a spreadsheet; Sub DeleteCells() 'Loop through cells A1:A10 and delete cells that contain an "x." For Each c In Range("A1:A8341") If c = "Client Total" Then c.EntireRow.Delete Next...

Hello All, I know this isnt a VB Forum but this is home so I will ask here first... Creating a user form, and I am still new to VB, here is my code; Private Sub cmdCancel_Click() Unload Me End Sub Private Sub cmdClearForm_Click() Call UserForm_Initialize End Sub Private Sub...

I just want to take a moment to thank everyone who has helped me out in the past. I am taking a supervisor position in my company and I wont be troubleshooting Office anymore, so will not be checking Tek-Tips as often. This really has been my best source for learning Excel. And I hope along the...

I need to use a value in a CELL to create a hyperlink. So for example If I had TEST in my cell I would like to click a button and go to http://Yahoo.com/Test This is what I have so far; Private Sub CommandButton1_Click() ActiveWorkbook.FollowHyperlink Address:="http://yahoo.com/", _...

Let me start off by saying I have ZERO experience with writing VB. I have an EXCEL spreadsheet that I do and INDEX/MATCH in a list. I know need to create a buttton that if it is not in the list I can click and add it to the list and then resort the list. Any help in this matter would be greatly...

Let me start off by saying I have ZERO experience with writing VB. I have an EXCEL spreadsheet that I do and INDEX/MATCH in a list. I know need to create a buttton that if it is not in the list I can click and add it to the list and then resort the list. Any help in this matter would be greatly...

OK, how about this.... I have a table where I am bring back the 1,2,3, result, and then doing a hlookup. The problem I have is if say the 1st and 2nd result match I only get the 1st result from my hlookup. Is there anyway around this? So I can get the two different results if they match? Hope...

OK, seems like I saw how to do his here not that long ago, but I cant find it for the life of me. I know MIN will bring back the smallest number in the range, but what could I do if I wanted to bring back the 2nd and 3rd smallest numbers in the range? Regards, Wray

hello, When clicking on the archieve database I get; "Entry not found in index." Anyone have any idea on how to fix this? Cheers, Wray

I have a user who is using NOTES 5.0.8 and she wants to add her signature. When she goes to the Actions menu Tools is not an option there. There is a mail tools option but there is no option to create a signature under that. Can someone tell me where we are going wrong or if there is a different...