Search results for query: *

I have some code that copies data and pastes it into new sheets - where the sheet names are variable depending on the data copied into them. Another thing about the code is that the number of new sheets will not always be the same - i could be from 1 new sheet to 4 new sheets. I want to move...

From my preivous thread about GetPivotData (http://www.tek-tips.com/viewthread.cfm?qid=1368354&page=1) I found I need to use dynamic named ranges - and looked at http://tek-tips.com/faqs.cfm?fid=1331 for instructions. I followed them, but I guess I am totally confused by them to. I keep...

I have several pivot tables that I use to summarize the data I need and then, currently, I am using vlookups to transfer the pivot table data to reports. This creates error sometimes - becuase the pivot tables can change each time I run the report - so I have to make sure that the vlookup is...

I have a beforesave event that checks to see if any changes were made to the spreadsheet, to check for errors, and to save and send an email. For some reason - the part of the code that is for saving and emailing is running twice - so 2 message boxes are shown and 2 emails are sent. I dont...

I have a spreadsheet that is used to request new location information - and have built in a macro tied to a command button to validate the fields to ensure all information is provided. The problem is that the end user does not HAVE to click this button and can save the file with errors. I...

I have windows XP with Microsoft Excel 2003. When I run my code, it works fine. One of my coworkers has Windows 2000 and Microsoft Excel 97 SR-2 and she gets a Runtime Error 13 - Type Mismatch when it runs through the program. The msgboxes open, but then she gets the runtime error when she...

I have a userform that allows the user to choose an order template from a combobox. I also have a ton of textboxes in the userform to return values based on the template chosen. I do not want the user to change the results in the textboxes... look dont touch. then they can approve the...

I have a userform with rules set up in the code to check to see if when certain options are selected, then to check to make sure that text was entered in the textboxes. the validation runs fine and my msgbox appears (through a macro that the userform code calls) but when you click ok in the msg...

2 questions: First, can you have 2 worksheet_change subs for a worksheet? I tried, but it only ran one. Second, I currently have 1 Worksheet_Change and it is performing 2 functions. The first looks to see if it needs to run the bankemp macro, based on cell information. the 2nd function it...

I have been researching a way to make invoke a macro based on changes in a cell and came across the worksheet_change event. I think this is what I need, and while I have some programming (though, very little) in my background, I am confused about the code for this event. What I have as an...